Home -> Usenet -> comp.databases.oracle -> Retrieving multiple rows into a Pro*C program

Retrieving multiple rows into a Pro*C program

From: Dana Schoonover <Dana.Schoonover_at_ATTGIS>
Date: Tue, 1 Nov 1994 21:17:42 GMT
Message-ID: <CyLxtI.3Lo_at_wtc35a.DaytonOH.NCR.COM> 






What is the best way for a Pro*C program to retrieve an entire row(s) from a 
table with a large number of columns(36)?



We've considered using a stored procedure, but haven't found the correct 
host-variable datatype to use as a parameter to receive a cursor%ROWTYPE.



Thanks for any suggestions.
Received on Tue Nov 01 1994 - 22:17:42 CET












Original text of this message