Re: dynamic sql

I don't have the documentation here, but there are functions/procedures in the dbms_sql package with names like 'bind_variable' and 'variable_value'.
These should do the trick. I think the package specification gives some info on how to use them. execute the following statement in sql*plus to see the package specification.

select text
from dba_source
where name = 'DBMS_SQL'
and type = 'PACKAGE'
order by line;

regards,

Pieter.

Jockus Brockus wrote:

> Can anyone tell me how I can use in- and outvariables when I call a
> procedure in dynamic sql?
>
> Thanks in advance,
>
> Jock
Received on Wed Oct 06 1999 - 00:00:00 CEST