We are using Execute Stored Procedure Smart procedure in our process. we are get

vahedullas1000

A Score Level 1

over 9 years ago

We are using Execute Stored Procedure Smart procedure in our process. we are getting below error while executing.
There is a problem with task “Execute Stored Procedure” in the process “POC_SP_ENTITY”. java.sql.SQLException: ORA-06550: line 1, column 7: PLS-00201: identifier 'ARMS_GET_ENTITY_INFO_SP' must be declared ORA-06550: line 1, column 7: PL/SQL: Statement ignored

Please help me out.

Thanks in advance....

Discussion posts and replies are publicly visible

0 Aleksi White
Appian Employee
over 9 years ago

Are you making sure to specify the direction of your parameters? i.e. IN vs OUT vs IN OUT
docs.oracle.com/.../storedprocedures.html
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Kartik
Certified Lead Developer
over 9 years ago

Looks like it is unable to locate the SP, it can also be because of not granting appropriate privileges (like execute) to the user account.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel