Re: Couple of PL/SQL questions

From: replace this with _at_ <_at_)xs4all.nl>
Date: Sat, 17 Apr 1999 17:57:39 GMT
Message-ID: <37125bdc.12269192@news.worldonline.nl>

Hi Ian,

>Is it possible to pass an argument to a PL/SQL program like you can to
>procedure?

Yes. Try %1 for example. It must also be possible with bind variables, but I do not have that info right now.

>When passing an argument to a procedure, can you use the argument to specify
>which schema's >tables you want to read e.g.

For this you can use the DBMS_SQL package. What you tried will not work. Look it up at the manual or email me if you're interested.

Received on Sat Apr 17 1999 - 12:57:39 CDT