apatel
Nintex Newbie

How to run oracle stored procedure

I am trying to run Oracle Stored Procedure and getting error. can anyone help me out on this. please find below screenshot for more information. connection is working okay but while I run query getting error.Stored_Procedure error.PNGStored_Procedure error_2.PNG

0 Kudos
Reply
6 Replies
emha
Automation Master
Automation Master

Re: How to run oracle stored procedure

EXECute is not an SQL command, it's just a sqlplus shortcut

 

try something like this

 

begin
   tempo.sp_CSSqlInsert( <list of args> );
end;

note as well ORACLE uses single quotes for strings

0 Kudos
Reply
apatel
Nintex Newbie

Re: How to run oracle stored procedure

I am getting following error. can you check is this the right way to pass parameters.

Stored_Procedure error_4.PNG

0 Kudos
Reply
emha
Automation Master
Automation Master

Re: How to run oracle stored procedure

ORACLE doens't understand MSSQL syntax...

so it doesn't recognize those @-signs. as well for named parameter list it doesn't use '=' but rather '=>' operator.

 

get in contact with the procedure developer or your DBA for proper syntax. 

0 Kudos
Reply
apatel
Nintex Newbie

Re: How to run oracle stored procedure

I am trying to run following which is working fine with values but not working with variables. can you help me fix it. please find below screenshot for more information.

 

Running succesfully while giving values in stored procedure parametersRunning succesfully while giving values in stored procedure parametersgetting error while running Sp using variablesgetting error while running Sp using variablesNintex_workflow_error.PNG

 

 

0 Kudos
Reply
emha
Automation Master
Automation Master

Re: How to run oracle stored procedure

that's expected - Run now takes variables literaly.

it can not know what values variables might have had in runtime.

you have to run workflow so that DB proc is called with variable values.

0 Kudos
Reply
Anita2020
Nintex Newbie

Re: How to run oracle stored procedure

Hello,

 

Good Afternoon,

There are 6 Oracle Executing Stored Procedures and Functions

Please go through this link: https://docs.oracle.com/cd/B28359_01/appdev.111/b28845/ch6.htm

I hope this link will guide you.

 

Thanks & Regards,

Anita

0 Kudos
Reply