Ask Your Question

Libreoffice Base with Oracle Driver - some query don't work! [closed]

asked 2012-06-11 10:35:34 +0200

MichaelB12 gravatar image

updated 2012-06-25 11:22:51 +0200

Hi all!

I need to use Oracle database in LibreOffice Calc. I added the library ojdbc6.jar and configured the access and create some query in Base.. It works!

But some query don't works:

When i want retrieve the system date: SELECT TO_CHAR(sysdate, 'YYYY') FROM DUAL;

Statut SQL: 42000 Code d'erreur: 904 / ORA-00904: "sysdate" : identificateur non valide

Or if i use "ROWNUM" to limit result.

Statut SQL: 42000 Code d'erreur: 904 / ORA-00904: ROWNUM : identificateur non valide

All that query works if direcly executed in sqlplus tool from Oracle.

Thanks in advance for your help! Michael

edit retag flag offensive reopen merge delete

Closed for the following reason question is not relevant or outdated by qubit
close date 2013-01-28 01:03:27.597135


No ideas ?

MichaelB12 gravatar imageMichaelB12 ( 2012-06-20 13:47:00 +0200 )edit

Hi @MichaelB12, It looks like you might have uncovered some bugs in the oracle connector. Please file a bug about your problem or problems! The QA team will be happy to help you track down these issues! Thanks!

qubit gravatar imagequbit ( 2013-01-28 01:02:59 +0200 )edit

1 Answer

Sort by » oldest newest most voted

answered 2012-06-25 11:21:38 +0200

MichaelB12 gravatar image

I still didn't find any solution for my problem with some query (rownum, sysdate) and i'm forced to abandon...

Any help would be very appreciated!


edit flag offensive delete link more

Question Tools


Asked: 2012-06-11 10:35:34 +0200

Seen: 560 times

Last updated: Jun 25 '12