Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
manoranjan_d
Specialist
Specialist

Stored Procedure

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

Labels (1)
6 Replies
marksouzacosta

Hi @manoranjan_d,

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

Regards,

Mark Costa

Read more at Data Voyagers - datavoyagers.net
Follow me on my LinkedIn | Know IPC Global at ipc-global.com

manoranjan_d
Specialist
Specialist
Author

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
Partner - Specialist II
Partner - Specialist II

Manoranjan_D_cognizant
Partner - Contributor II
Partner - Contributor II

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

nhoover
Luminary
Luminary

Try calling your SP like this:
SQL EXEC TEST_POC_PROC !EXECUTE_NON_SELECT_QUERY;
Manoranjan_D_cognizant
Partner - Contributor II
Partner - Contributor II

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