Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Couple of PL/SQL questions

Couple of PL/SQL questions

From: Iancrozier <iancrozier_at_aol.com>
Date: 9 Apr 1999 14:15:29 GMT
Message-ID: <19990409101529.27675.00000553@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 Fri Apr 09 1999 - 09:15:29 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US