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.
EXECute is not an SQL command, it's just a sqlplus shortcut
try something like this
begin tempo.sp_CSSqlInsert( <list of args> );
note as well ORACLE uses single quotes for strings
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.
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.
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,