Home -> Usenet -> comp.databases.oracle -> Embedded PL/SQL : how to distinguish input host vars from output ones ?

Embedded PL/SQL : how to distinguish input host vars from output ones ?

From: Rama <rduggal_at_vcomcss1.telecom.com.au>
Date: 20 Feb 1995 04:45:17 GMT
Message-ID: <3i96ot$6m1_at_rodin.tansu.com.au> 






Someone out there must know the answer to this :




When using Dynamic SQL method 4 (ref Precompiler manual), the
"DESCRIBE BIND VARIABLES" call get you the info about 
both input and output variables used in the PL/SQL block. 
Now when you scan this info in the SQLDA's, how can you find out 
which variables are to be bound to the input and to the 
output respectively. 



I have been using Embeded SQL with the PRO*C precompiler, and am going to 
start experimenting with PL/SQL. The manual for PL/SQL says you can't 
FETCH from a PL/SQL block. So how do you get multiple rows here ?



I guess the second question has solutions, but can some one the first one ??
Received on Mon Feb 20 1995 - 05:45:17 CET












Original text of this message