Home » SQL & PL/SQL » SQL & PL/SQL » How to refer to the whole new record (:new) in table trigger
How to refer to the whole new record (:new) in table trigger [message #207918] Thu, 07 December 2006 06:02 Go to next message
hrforafaq
Messages: 8
Registered: July 2005
Junior Member
Salut
As it is known, in a table trigger, to refer to a col of the new record to be inserted we type :new.colname but what should we use to refer to the whole new record.
I don't know if it is possible or not.
I use :new but it doesn't work.
I need it so i can assign it to record variable just in one instruction rather than to assign column one by one.
I have oracle 9.2.0.6 on win 2k pro.
thanks.
Re: How to refer to the whole new record (:new) in table trigger [message #207922 is a reply to message #207918] Thu, 07 December 2006 06:30 Go to previous messageGo to next message
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
There's no way of doing it that I know of.
Re: How to refer to the whole new record (:new) in table trigger [message #207931 is a reply to message #207918] Thu, 07 December 2006 07:31 Go to previous messageGo to next message
MarcL
Messages: 455
Registered: November 2006
Location: Connecticut, USA
Senior Member
You're out of luck mate, I don't believe this is possible
Re: How to refer to the whole new record (:new) in table trigger [message #207942 is a reply to message #207918] Thu, 07 December 2006 08:19 Go to previous messageGo to next message
joy_division
Messages: 4641
Registered: February 2005
Location: East Coast USA
Senior Member
This may be of some use to you:

http://asktom.oracle.com/pls/ask/f?p=4950:8:::::F4950_P8_DISPLAYID:59412348055
Re: How to refer to the whole new record (:new) in table trigger [message #207958 is a reply to message #207942] Thu, 07 December 2006 08:47 Go to previous message
hrforafaq
Messages: 8
Registered: July 2005
Junior Member
It seems that it's not possible. Maybe because they are just bind variables not regular ones.
Thanks to all of you.
Previous Topic: Euro Sign
Next Topic: ordering by a non-database item
Goto Forum:
  


Current Time: Wed Dec 07 05:13:35 CST 2016

Total time taken to generate the page: 0.09816 seconds