Re: Couple of PL/SQL questions

You have to use the DBMS_SQL package to be able to use dynamic sql. In short, you create a text string of the sql-statement you want to issue and then pass it to the DBMS_SQL package. It's not possible to pass arguments to an sql-statement like you would to a PL/SQL program or function.

Regards

Jan-Hein

Iancrozier <iancrozier_at_aol.com> schreef in artikel <19990409101529.27675.00000553_at_ng-fq1.aol.com>...
> Is it possible to pass an argument to a PL/SQL program like you can to
> procedure?
>
> e.g. ( variable_in in number)
>
> When passing an argument to a procedure, can you use the argument to
specify
> which schema's
> tables you want to read e.g.
>
> select * from variable_in.table1;
>
> where variable_in is passed to the procedure.
>
> I have tried, but the procedure compiles with errors.
>
>
> Thanks in advance
>
> Ian Crozier
>
Received on Wed Apr 14 1999 - 03:11:30 CDT