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: 
V_Ortis
Contributor III
Contributor III

Execute a Oracle Procedure in Qlik Cloud

Hello, i need a execute a oracle job in my Qlik Cloud, in my app i try this: 

SQL
BEGIN
DBMS_SCHEDULER.RUN_JOB('SOLUS_NINF.J_CARGAS_GUIAS');

but receive this error:

Ocorreram os seguintes erros:
Internal error. (Connector error: Status(StatusCode="InvalidArgument", Detail="ERROR [HY000] [Qlik][OracleOCI] (3000) Oracle Caller Interface: ORA-06550: line 2, column 55: PLS-00103: Encountered the symbol "end-of-file" when expecting one of the following: := . ( % ; "))

V_Ortis_0-1741631723415.png

 

 

 

2 Replies
fmarvnnt
Partner - Creator III
Partner - Creator III

Are you sure the Oracle syntax is correct?

FMa

 

V_Ortis
Contributor III
Contributor III
Author

Yes, when I run it in SQL Developer the process happens