Hi all.
I would like to write a PLSQL script that I can call from PLSQL but
pass a parameter. I have not been able to locate information in the
newsgroups or in the documentation. (Don't mean it ain't there, of
course.)
Of course, I could write a stored procedure but I don't want to save
this script in the database. If I did that I'd have to propagate it to
several databases and I want it to be a general script.
It had occured to me that I could cheat a little and write a shell
script to accept the command line parameters and wrap my SQL script
within the shell script. The problem with that is that I'd have to
embed the database name as well as a userid/password into the script,
leaving me with the need for a different copy of the shell script for
each database.
No, the best way for me (I think) is a database-independent script.
Since it will retrieve data from the data dictionary, it won't matter
which database it's running on; those "tbles" exist in every database.
Any ideas?
Thanks.
+---------- Jacob Salomon JSalomon_at_bn.com -- -------------- ------+
| Conservative (n): A statesman who is enamored of existing evils,|
| as distinguished from the Liberal, who wishes to replace them |