Stored Procedure

[manoranjan_d]

Hi All,

We have created simple stored procedure in oracle DB and same has been called in the below qliksense script

LIB CONNECT TO 'connection_name';

sql exec
TEST_POC_PROC;

but I am getting an error , pls let me know how we can fix this issue.

Started loading data
Connected
{0}
The following error occurred:
ERROR [HY000] [Qlik][OracleOCI] (3000) Oracle Caller Interface: ORA-00900: invalid SQL statement

[marksouzacosta]

Hi @manoranjan_d,

Try this link: Solved: How to Execute Oracle Stored Procedure with multip... - Qlik Community - 1889943

Regards,

Mark Costa

[manoranjan_d]

Hi,

its not working out, actually the stored are developed for angular API which pass input and o/p parameter and also they are not normal stored proc its have cursor concept in that. the same store proc has be executed in qlik

[p_verkooijen]

@manoranjan_d 

Use CALL

SQL EXEC = MS SQL
SQL CALL = Oracle 

https://community.qlik.com/t5/Official-Support-Articles/Calling-a-stored-procedure-or-function-in-Or...

[Manoranjan_D_cognizant]

 how to connect the external web  application with parameter thru api?

[nhoover]

Try calling your SP like this:
SQL EXEC TEST_POC_PROC !EXECUTE_NON_SELECT_QUERY;

[Manoranjan_D_cognizant]

Connector reply error: Unknown substring, string, or value at (2,1): '!EXECUTE_NON_SELECT_QUERY'

getting error like this now we have decieded to go with api connection bcoz all these proc are used cursor for web application , so getting data from web application thru rest api connector and passing the parameter any help on this