Couple of PL/SQL questions

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