https://bugs.freedesktop.org/show_bug.cgi?id=51404
Bug #: 51404
Summary: : Libreoffice Base with Oracle - SYSDATE, ROWNUM don't
work in query!
Classification: Unclassified
Product: LibreOffice
Version: 3.5.4 release
Platform: Other
OS/Version: All
Status: UNCONFIRMED
Status Whiteboard: BSA
Severity: normal
Priority: medium
Component: Database
AssignedTo: [email protected]
ReportedBy: [email protected]
Problem description:
--------------------
Cannot execute some query (with sysdate, rownum) when used with Oracle
database.
There is already a bug from 2010 that refer to this problem may be (READ IT):
https://issues.apache.org/ooo/show_bug.cgi?id=108593
Steps to reproduce:
--------------------
- Add the library ojdbc6.jar
- Run query in Base
- 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 in query.
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.
Current behavior:
--------------------
I got a error code, see above..
Expected behavior:
--------------------
To return the result..
Platform (if different from the browser):
Browser: Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:13.0) Gecko/20100101
Firefox/13.0.1
--
Configure bugmail: https://bugs.freedesktop.org/userprefs.cgi?tab=email
------- 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
