Discussion Board for collaboration related to QlikView App Development.
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:37000sql execute getallusers
How to call oracle procedure?
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,
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?