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

Home -> Community -> Mailing Lists -> Oracle-L -> bad BIND variable

bad BIND variable

From: Bunyamin K. Karadeniz <bunyamink_at_havelsan.com.tr>
Date: Mon, 12 Nov 2001 01:52:16 -0800
Message-ID: <F001.003C20C7.20011112012019@fatcity.com>

I WANT TO CREATE a dynamic trigger where inside;
 :new.column_name occurs and column_name
changes in a loop .
 

DECLARE
cursor c1 is select column_name from
arsiv.logged_columns where table_name = <FONT color=#0000f0>'K_IMID_KURUM' ;kolon
c1%rowtype;
BEGINFOR kolon IN c1
LOOPye := :new.||kolon.column_name;

.................

END;
 

But the problem is it gives bad bind variable error for ye := :new.||kolon.column_name;
How can I correct this error ?
Thank you .. /
Bunyamin Received on Mon Nov 12 2001 - 03:52:16 CST

Original text of this message

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