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
