===================================================
The following error has occurred:
ORA-06550: line 2, column 2:
PLS-00306: wrong number or types of arguments in call to 'PROC_GET_CLIENT_INFO'
ORA-06550: line 2, column 2:
PL/SQL: Statement ignored
===================================================
Here's my package specification:
CREATE OR REPLACE PACKAGE pkg_Search
AS
TYPE client_TableRows IS REF CURSOR
RETURN isis.client%ROWTYPE;
PROCEDURE proc_get_client_info (
arg_client_id_nbr IN OUT isis.CLIENT.CLIENT_ID_NBR_NEW%TYPE,
arg_cursor IN OUT client_TableRows);
END pkg_Search;
Here's my package body:
CREATE OR REPLACE PACKAGE BODY pkg_Search
AS
procedure proc_get_client_info (
arg_client_id_nbr IN OUT isis.client.client_id_nbr_new%type,
arg_cursor IN OUT client_TableRows) IS
BEGIN
open arg_cursor FOR
select
*
from isis.client
where client_id_nbr_new=arg_client_id_nbr;
END proc_get_client_info;
end pkg_Search;
Any help would be appreciated. Thanks.
Nick Han
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
