Skip to Content (Press Enter)
2025-08-22 10-19-44
Pramod Jain
 
MVP
5Views
2Comments
Calling Oracle Stored Procedure from Advance Query
Question
We are new to outsystem and want to call Oracle Stored Procedure from Advance Query with\without input output parameter.
Here is my example iam using following syntex
exec PRC_GET_TEST_DATA 
where 
PRC_GET_TEST_DATA  is the name of my SP and this SP doesnt need any input parameter.

Here is the Error Log From Service Center:
Error in advanced query GetTestData in Preparation in HomePage in MainFlow in NetlinkTest (exec PRC_GET_TEST_DATA): ORA-00900: invalid SQL statement
0
0
30 Jul 2013
Copy Link
2019-03-09 06-12-44
Mac mac
Hi Pramod,

First, Welcome to Outsystems :)
This might help: https://www.outsystems.com/forums/discussion/3208/stored-procedure-out-parameters/

Regards,
Mark Chua
0
0
30 Jul 2013
Copy Link
2012-03-16 12-21-09
João Rosado
Staff
Hi Pramod,

Since your procedure doesn't have any inputs/outputs you should be able to call it directly from the advanced query. But you will probably have to turn it into pl-sql.
Try this:

BEGIN
    PRC_GET_TEST_DATA();
END;

Also make sure the platform runtime user has permissions for it. You may also need to prefix the procedure with the schema name if it's not on the platform admin schema.

Regards,
João Rosado
0
0
30 Jul 2013
Copy Link
Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.