character string buffer too small [message #19986] |
Mon, 22 April 2002 20:23 |
Milind S Deobhankar
Messages: 33 Registered: January 2002
|
Member |
|
|
Hi,
I am having one trigger it perfectly works fine for individual records or even records upto 1000 or so
But that trigger fails with the following error
SQL> update login set password=password
2 /
update login set password=password
*
ERROR at line 1:
ORA-06502: PL/SQL: numeric or value error: character string buffer too small
ORA-06512: at "MY.TRIGGERABC", line 4
ORA-06512: at "MY.UPDATE_MAINLOGIN", line 21
ORA-04088: error during execution of trigger MY.UPDATE_MAINLOGIN'
THE ABOVE TRIGGERS WORK FINE WHEN I UPDATE LIKE THIS
UPDATE LOGIN SET PASSWORD='MILIND' WHERE USERID='MILIND'
/
BUT IT FAILS FOR
UPDATE LOGIN SET PASSWORD='MILIND'
/
I AM HAVING 10000 ROWS IN THAT TABLE
SO PLEASE HELP ME HOW TO SOLVE THIS PROBLEM
THANKS IN ADVANCE
|
|
|
|