Calling PL/SQL package (that returns a table) from a package
Date: 25 Sep 2002 05:53:35 -0700
Message-ID: <3a9d48b7.0209250453.1a947a47_at_posting.google.com>
TYPE tbl_cust_order_id IS TABLE OF sysadm.customer_order.id%TYPE
INDEX BY BINARY_INTEGER; PROCEDURE called_pkg (
p_cust_order_id OUT tbl_cust_order_id
);
PROCEDURE called_varchar2_pkg (
p_cust_order_id OUT varchar2
);
END eva_test_called_pkg;
/
CREATE OR REPLACE PACKAGE BODY eva_test_called_pkg
AS
PROCEDURE called_pkg (p_cust_order_id OUT tbl_cust_order_id) IS
TYPE tbl_act_cost_ratio IS TABLE OF NUMBER INDEX BY BINARY_INTEGER; v_cust_order_id sysadm.cust_order_line.cust_order_id%TYPE; p1_act_cost_ratio tbl_act_cost_ratio; BEGIN p_cust_order_id (1) := 10; p_cust_order_id (2) := 11;
END called_pkg;
PROCEDURE called_varchar2_pkg (p_cust_order_id OUT VARCHAR2) IS
v_cust_order_id VARCHAR (30);
BEGIN
p_cust_order_id := 'OK';
END called_varchar2_pkg;
END eva_test_called_pkg;
/
I get the following error when I compile:
PLS-00306: wrong number or types of arguments in call to 'CALLED_PKG' Received on Wed Sep 25 2002 - 14:53:35 CEST