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

In article <3i96ot$6m1_at_rodin.tansu.com.au>, Rama <rduggal_at_vcomcss1.telecom.com.au> writes:
|> 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.

You really can't tell this. It depends on the block which you are parsing. The precompiler does the same thing for all bind variables anyway, regardless of whether they are input or output. Just passes the address of the variable to the database to be used for the placeholder. Your program shouldn't care either. Presumably whomever wrote the block knows this, and will either put a value in (for input vars) or look at the result (for output vars).

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

You don't. You can bind a C array to a PL/SQL table however.

|>
|> I guess the second question has solutions, but can some one the first one ??
|>
|>
|>
Received on Tue Feb 21 1995 - 18:56:10 CET