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 -> Re: Help on Paramater Passing

Re: Help on Paramater Passing

From: Mark C. Stock <mcstockX_at_Xenquery>
Date: Mon, 6 Mar 2006 11:35:09 -0500
Message-ID: <WJCdnSS5PNkg-ZHZnZ2dnUVZ_s-dnZ2d@comcast.com>

<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)

++ mcs Received on Mon Mar 06 2006 - 10:35:09 CST

Original text of this message

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