Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: bind variable

Re: bind variable

From: Niall Litchfield <niall.litchfield_at_gmail.com>
Date: Mon, 6 Nov 2006 13:50:01 +0000
Message-ID: <7765c8970611060550h1d7c0fd5ob8c86c7cd7886a1b@mail.gmail.com>


Unless I'm missing something obvious you'd be wanting to use the :new.<columnname> and :old.<columnname> construct in your trigger.

On 11/6/06, David Boyd <davidb158_at_hotmail.com> wrote:
>
> Hi All,
>
> We have lots of row level audit triggers that audit update and delete on
> every column for each row. Our database is 9.2.0.6 and cursor_sharing
> parameter is set to exact. Therefore the SQL statements in the trigger
> that
> differ in some literals are not shared. Let's say that we don't want
> change
> the cursor_sharing parameter and would like to use bind variable. But
> bind
> variable can not be used in the trigger. The alternative is to create a
> procedure that uses bind variable and is called by the trigger. Does any
> one have experience on this? How is the performance with calling the
> procedure from trigger back and forth? The database is shared by many
> home
> grow and vendor applications. If we change the cursor_sharing to force,
> what are the pros and cons?
>
> Thanks for any input.
>
> Dave
>
> _________________________________________________________________
> Add a Yahoo! contact to Windows Live Messenger for a chance to win a free
> trip!
>
> http://www.imagine-windowslive.com/minisites/yahoo/default.aspx?locale=en-us&hmtagline
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

-- 
Niall Litchfield
Oracle DBA
http://www.orawin.info

--
http://www.freelists.org/webpage/oracle-l
Received on Mon Nov 06 2006 - 07:50:01 CST

Original text of this message

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