Bug 52156

Summary: error ORA-00933 : Sql command not properly ended
Product: LibreOffice Reporter: Roberto Barraco <roberto.barraco>
Component: DatabaseAssignee: Not Assigned <libreoffice-bugs>
Status: NEEDINFO --- QA Contact:
Severity: normal    
Priority: medium CC: dr, iplaw67, qubit, todventtu
Version: 3.5.5.3 release   
Hardware: Other   
OS: All   
Whiteboard:
i915 platform: i915 features:

Description Roberto Barraco 2012-07-16 15:39:09 UTC
Hi 
I am a newbie of LibreOffice but I often use  MSACCESS. I have started drwawing a query using "Query Design". My goal is to query an Oracle Table via JDBC. The conenction is up . After I push the F5 button I receive the mentioned error. The information about the SQL statemen show this :

SELECT "FORNITORE", "RAPPORTI" FROM "SIDATI"."FORNITORI" AS "FORNITORI"

I've tried SQL directly and seems that Oracle doesn't like 'AS "FORNITORI"'. IF I erase these words the F5 works fine.
Any help will be accepted
Comment 1 Robinson Tryon (qubit) 2014-11-14 22:45:12 UTC
(In reply to Roberto Barraco from comment #0)
> Hi 
> I am a newbie of LibreOffice but I often use  MSACCESS. I have started
> drwawing a query using "Query Design". My goal is to query an Oracle Table
> via JDBC. The conenction is up . After I push the F5 button I receive the
> mentioned error. The information about the SQL statemen show this :
> 
> SELECT "FORNITORE", "RAPPORTI" FROM "SIDATI"."FORNITORI" AS "FORNITORI"
> 
> I've tried SQL directly and seems that Oracle doesn't like 'AS "FORNITORI"'.
> IF I erase these words the F5 works fine.
> Any help will be accepted

Hi Roberto,
Did you ever get this problem sorted out?  Can you still reproduce the problem using modern (4.3-era) builds of LibreOffice?

(After you comment, please change the status back to UNCONFIRMED. Thanks!)

Status -> NEEDINFO
Comment 2 Alex Thurgood 2015-01-03 17:41:26 UTC
Adding self to CC if not already on

Use of freedesktop.org services, including Bugzilla, is subject to our Code of Conduct. How we collect and use information is described in our Privacy Policy.