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

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

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. 

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.

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.

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