Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: PL/SQL Parameter arrays

Re: PL/SQL Parameter arrays

From: Paul Dixon <paul.gp.dixon_at_tinnedham.bt.com>
Date: Mon, 1 Jul 2002 09:55:18 +0100
Message-ID: <afp5nm$n4e$1@pheidippides.axion.bt.co.uk>


> 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 := 'test_stroke';
> sDictionary := test_dict1';
>
> remote_pipe.pr_proc(sToEncode,
> sDictionary,
> nErrNum,
> sErrMsg,
> nEncoderCount,
> saEncoderType,
> naRank,
> naMatch,
> saRetEncoder,
> saTermIfo);
>
> exception
> when others then
> dbms_output.put_line(sqlerrm);
> end;
> /

Cliff,

does the spec for remote_pipe.pr_proc have the same datatypes for its parameters as those that you are trying to pass it ?

--
Paul Dixon
paul.gp.dixon_at_bt.tinnedham.com
(Remove canned meat to reply)
Received on Mon Jul 01 2002 - 03:55:18 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US