OraFAQ Forum: SQL & PL/SQL » long to a long in a trigger barf

Home » SQL & PL/SQL » SQL & PL/SQL » long to a long in a trigger barf

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

long to a long in a trigger barf [message #20503]

Thu, 30 May 2002 10:11

DRE
Messages: 9
Registered: March 2002

Junior Member

Hi I seem to have a problem in 8.1.6 where I have a before update trigger writing the contents of a table entry to a history table. The problem is that one of the fields is a long. When I update the table, it throws an error stating that it cant bind a long into the next field. However, the history table is the same so it is going into a long. I've checked that I didnt setup a misalignment and such. Anybody got a workaround? Tks. DRE

Report message to a moderator

Re: long to a long in a trigger barf [message #20507 is a reply to message #20503]

Thu, 30 May 2002 11:33

Todd Barry
Messages: 4819
Registered: August 2001

Senior Member

http://asktom.oracle.com/pls/ask/f?p=4950:8:::::F4950_P8_DISPLAYID:1365003164221

Report message to a moderator

Previous Topic:	about pls_integer
Next Topic:	Abt optimizer

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Apr 26 23:37:35 CDT 2024