topic How to call Oracle procedure ? in QlikView

How to call Oracle procedure ?

Sat, 09 Oct 2010 10:03:37 GMT

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?

Sat, 09 Oct 2010 11:16:42 GMT

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

Tue, 12 Oct 2010 04:33:48 GMT

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?