Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Oracle Database cannot retrieve tables #132

Open
mail2julian opened this issue Mar 16, 2020 · 1 comment
Open

Oracle Database cannot retrieve tables #132

mail2julian opened this issue Mar 16, 2020 · 1 comment

Comments

@mail2julian
Copy link

mail2julian commented Mar 16, 2020

hi,
i was trying to connect oracle database to jupyterlab using this sql extension.
The connection was successful, i was able to run custom SQL query from the extensions.
It also showed the tables in the database, but when i tried to open a table it gives me this error:

(cx_Oracle.DatabaseError) ORA-00936: missing expression
[SQL: SELECT FROM DUAL
WHERE ROWNUM <= :param_1]
[parameters: {'param_1': 1000}]
(Background on this error at: http://sqlalche.me/e/4xp6)

But if i try to get the same table data from the Custom SQL query it shows the data.
this error only occurs in Oracle DB, all the other supported Databases are working fine.

pls help to resolve error.

thank you.

@ckiefer
Copy link

ckiefer commented May 25, 2020

I have exactly the same issue. Any comments are highly appreciated.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants