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

Home -> Community -> Usenet -> c.d.o.misc -> Stored Proc clipping results

Stored Proc clipping results

From: Brad Andrews <Brad.Andrews_at_sabre.com>
Date: Thu, 18 Mar 1999 09:51:04 -0600
Message-ID: <36F120E6.9FB0DE07@sabre.com>


I have a stored procedure that is getting a bunch of data and putting it into an array I pass in as an OUT parameter. For some reason, though I specify the size of the array as 1000, it is only returning the first 55 answers. I used a temporary table to check, and it seems to be properly getting all the values, but it ends up with only 55 valid rows in the output, with empty strings in the rest of the elements.

Does anyone know what might be going on?

I am using Oracle 7 on a Sun box with ProC for the front end.

Brad Received on Thu Mar 18 1999 - 09:51:04 CST

Original text of this message

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