using bind variables for procedures/packages

From: Benny Pei <bplegend_at_yahoo.com>
Date: Wed, 20 Aug 2003 17:14:24 -0800
Message-ID: <F001.005CBD42.20030820171424@fatcity.com>

Hi,

I know how to do it for regulard query statement but I wasn't sure how to do it with procedures and packages.

I have this procedure. e.g.

I have this procedure
'begin

  run_proc ('foo','blah');
end;
'

the procedure will be called either in a perl script. How would I change it so that it uses bind variables? Because it will be executed many times every hour and every day.

thanks,

benny

---

Do you Yahoo!?
Yahoo! SiteBuilder - Free, easy-to-use web site design software http://sitebuilder.yahoo.com

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Benny Pei
  INET: bplegend_at_yahoo.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Received on Wed Aug 20 2003 - 20:14:24 CDT