First time here? Check out the FAQ!
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
answered 2012-06-25 11:21:38 +0200MichaelB12
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