Stored Procedure calling a package in Oracle

_AnonymousUser — Sat, 16 Nov 2024 13:35:21 GMT

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

Re: Stored Procedure calling a package in Oracle

_AnonymousUser — Thu, 28 Jan 2010 14:24:28 GMT

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

topic Stored Procedure calling a package in Oracle in Talend Studio

Stored Procedure calling a package in Oracle

Re: Stored Procedure calling a package in Oracle