Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to call Oracle procedure ?

I write simple sql statement,such as

sql execute getallusers;

It got an error msg:

SQL Error:[Oracle][ODBC]Syntax error or access violation.
SQL Scriptline:
SQL State:37000
sql execute getallusers

How to call oracle procedure?

2 Replies
Not applicable
Author

1. Make sure to open the database in read write mode

You can call a function like that: SQL SELECT function() as field ...

and a procedure like SQL CALL prc()

hope this helps,

Matthias

Not applicable
Author

I had set "read write mode" .however, qv got an error

SQL Error:[Oracle][ODBC][Ora]ORA-01456: ??? READ ONLY ?????????/??/????
ORA-06512

How to solve this error?