Re: PL/SQL Parameter arrays

> 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)