I am trying to execute this test package that i have, but I have encountered this error:

===================================================
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;
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]

Reply via email to