java.sql.SQLException ORA-06550 in process builder

Hi all,

Am using Database stored procedure activity in process builder, while execution time am getting the following exception, I was created sample package to test. Anything that was I missed??

In the activity search name is coming like PACK1. SCHEM2A.FUN1

CREATE OR REPLACE PACKAGE PACK1 AS

FUNCTION FUN1 RETURN VARCHAR2;
END PACK1;

CREATE OR REPLACE PACKAGE BODY PACK1 AS
FUNCTION FUN1 RETURN VARCHAR2 IS
BEGIN
RETURN('HELLOW FROM FUN1');
END FUN1;
END PACK1;

java.sql.SQLException: ORA-06550: line 1, column 19:

PLS-00302: component 'SCHEM2A' must be declared

ORA-06550: line 1, column 7:

PL/SQL: Statement ignored

at oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:70)

at oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:110)

at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:171)

....

Find more posts tagged with

Comments

Viswa

Syntax to execute an Oracle package is PackageName.Function/Procedure Name

Try calling PACK1.FUN1.

gangadhara

Thanks for your reply Viswa. if i try to replace existing name with PACK1.FUN1 it was showing "procedure or function not found" error msg it is showing

Viswa

What is "SCHEM2A" here?

gangadhara

when we search function name in activity it will shows like that. package name. schema name. function name. i attached the screen shot just see.

Viswa

Can't you type "PACK1.FUN1" or "SCHEM2A.PACK1.FUN1" there?

gangadhara

Appricate your willingness to help . I tried in both ways it was showing same error msg. please find the screen shots. even sql function code also there in my first post.

Viswa

Please try to re-create the package as

CREATE OR REPLACE PACKAGE SchemaName.PackageName

If it still won't work, then there may be permission issue in Oracle side, please check with your DBA

gangadhara

Viswa thanks for your reply. it was not allowing me create the package as you specified. i was tested using pl/sql it was exicuting properly no issues. is any way to check the permission.

CREATE OR REPLACE PACKAGE SEDS2A.PACK1 AS
FUNCTION FUN1 RETURN VARCHAR2;
END SEDS2A.PACK1;

CREATE OR REPLACE PACKAGE BODY SEDS2A.PACK1 AS
FUNCTION FUN1 RETURN VARCHAR2 IS
BEGIN
RETURN('HELLOW FROM FUN1');
END FUN1;
END SEDS2A.PACK1;

Viswa

Please make sure that the process builder connect to Oracle with the correct user name.

gangadhara

Viswa thanks for your help. Am able to do all Database operation read and write but only problem with the stored procedures. see the screen shot it shows database connected to sucessfully.