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

Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now
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