PL/SQL Parameter array help

From: Noodles <noodles_at_aol.com>
Date: 30 Jun 2002 12:55:38 GMT
Message-ID: <20020630085538.16563.00001587_at_mb-mb.aol.com>

HP Unix 11
Oracle 8.1.7

I'm a relative newbie am trying to get a 2 returned arrays ( one is varchar and one is number) from a procedure call back into local variable types.

I've tried "typing" my variable using a PL/SQL table but it still gives me a type mismatch. Am I missing something?

{Code}
set serveroutput on size 1000000;
 declare

      type str_array is table of varchar2(255) index by binary_integer;
      type num_array is table of number(9) index by binary_integer;

      mycount number;
      sToEncode varchar2(200);
      sDictionary varchar2(200);
      nErrNum number;
      sErrMsg varchar2(200);
      nEncoderCount number;
      saEncoderType str_array;
      naRank num_array;
      naMatch num_array;
      saRetEncoder str_array;
      saTermInfo str_array;

begin
      sToEncode := 'stroke';
      sDictionary := ‘MedDRA';

remote_pipe.pr_proc(sToEncode,sDictionary,nErrNum,sErrMsg,nEncoderCount,sa EncoderType,naRank,naMatch,saRetEncoder,saTermInfo);

exception

     when others then
     dbms_output.put_line(sqlerrm);

end;
/
exit;

TIA,
Clliff Received on Sun Jun 30 2002 - 14:55:38 CEST