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
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!
???
LibreOffice is made available by volunteers around the globe, backed by a charitable Foundation. Please support our efforts: Your donation helps us to deliver a better product!
Asked: 2012-06-11 10:35:34 +0200
Seen: 151 times
Last updated: Jun 25 '12
Content on this site is licensed under a Creative Commons Attribution Share Alike 3.0 license.
No ideas ?
MichaelB12 ( 2012-06-20 13:47:00 +0200 )editHi @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 ( 2013-01-28 01:02:59 +0200 )edit