Re: Help on Paramater Passing

<amerar_at_iwc.net> wrote in message
news:1141662613.297927.24250_at_u72g2000cwu.googlegroups.com...
: Hi All,:: Can you pass a parameter to an anonymous block? We have a Unix script: which will run and compile some procedures for us. For checking, we: want to select the status column and make sure everything is valid.:: Rather than spool all this junk to a file, we were going to write an: anonymous block, passing in the procedure name, and check its status.:: But, how do I pass a parameter to an anonymous block?:: Thanks!:

depends...

since UNIX can't run PL/SQL, i'm assuming you're running the anonymous block
in SQL*Plus -- in that case you can use a SQL*Plus bind variable within the
block. the find variable can be read and written in the block, then
displayed in SQL*Plus via print (or via dbms_output in the block)