Home -> Usenet -> comp.databases.oracle -> PL/SQL procedures returning large data array to SQLWindows

PL/SQL procedures returning large data array to SQLWindows

From: Wolfgang Diestelkamp <wolfgang.no.o.spam.diestelkamp_at_telia.se>
Date: 1997/11/10
Message-ID: <34670154.2486_at_telia.se>#1/1 







We are having problems with a PL/SQL procedure that should return a
large array of strings like



TYPE sArray IS TABLE OF VARCHAR2(256) INDEX BY BINARY_INTEGER;



PROCEDURE Read_strings 


  (nStrings IN OUT number,


   sStrings IN OUT sArray);



Where the the procedure fill the array with ~120 strings. Everything
works fine, but if I define sArray with a string-length greater than 256
the procedure call crashes (somewhere above Oracle it seems, since I
can't trap any exception).


Any hints anyone ?



/WD
Received on Mon Nov 10 1997 - 00:00:00 CET












Original text of this message