Bug 58796 - : Query to Oracle database in Base / Missing function
Summary: : Query to Oracle database in Base / Missing function
Status: RESOLVED DUPLICATE of bug 51404
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Base (show other bugs)
Version:
(earliest affected)
3.6.4.3 release
Hardware: Other Linux (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard: BSA
Keywords:
Depends on:
Blocks:
 
Reported: 2012-12-27 08:13 UTC by MichaelB
Modified: 2012-12-28 13:59 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description MichaelB 2012-12-27 08:13:47 UTC 
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
Comment 1 Alex Thurgood 2012-12-28 13:59:37 UTC 
Surely this is a DUP of 
https://bugs.freedesktop.org/show_bug.cgi?id=51404

*** This bug has been marked as a duplicate of bug 51404 ***