Stored Procedure calling a package in Oracle

One Star

Stored Procedure calling a package in Oracle

Hi All,
I have seen how talend calls a function within a package but i cannot seem to call a procedure within a package from Oracle,
EG: in PLSQL
CREATE OR REPLACE PACKAGE BODY PART_CATALOG_API IS
PROCEDURE NEW__ (
part_no_ IN VARCHAR2 )
IS
BEGIN
General_SYS.Init_Method(lu_name_, 'PART_CATALOG_API', 'Exist', TRUE);
IF (NOT Check_Exist___(part_no_)) THEN
Error_SYS.Record_Not_Exist(lu_name_);
END IF;
END Exist;

END PART_CATALOG_API;
So if i try to call PART_CATALOG_API.Exist__
i get an error
Exception in component tOracleSP_1
java.sql.SQLException: ORA-06550: line 1, column 13:
PLS-00222: no function with name 'NEW__' exists in this scope
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored

Can Talend call procedures within Packages ? If so what am i doing wrong
TIA
Gresham
One Star

Re: Stored Procedure calling a package in Oracle

sorry typo error.
i meant to type
So if i try to call PART_CATALOG_API.NEW__