https://bugs.freedesktop.org/show_bug.cgi?id=58796
Priority: medium
Bug ID: 58796
Assignee: [email protected]
Summary: : Query to Oracle database in Base / Missing function
Severity: normal
Classification: Unclassified
OS: Linux (All)
Reporter: [email protected]
Hardware: Other
Whiteboard: BSA
Status: UNCONFIRMED
Version: 3.6.4.3 release
Component: Database
Product: LibreOffice
Problem description:
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
with simple select query!
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 query works if direcly executed in sqlplus tool from Oracle.
Thanks in advance!
Operating System: Ubuntu
Version: 3.6.4.3 release
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
