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