| Trigger questions (merged) [message #253759] |
Tue, 24 July 2007 15:12  |
madhu_msinus@yahoo.co.in
Messages: 12
Registered: July 2007
Location: usa
|
Junior Member |
|
|
can any one help me out from this...
SQL> create or replace trigger statement_level
2 before update on orders
3 declare
4 vmsg varchar2(20):='statement level trigger fired';
5 begin
6 dbms_output.put_line(vmsg);
7 end satement_level;
8 /
Trigger created.
SQL> UPDATE ORDERS SET SOMECOLUMN = 'XYZ';
UPDATE ORDERS SET SOMECOLUMN = 'XYZ'
*
ERROR at line 1:
ORA-06502: PL/SQL: numeric or value error: character string buffer too small
ORA-06512: at "SCOTT.STATEMENT_LEVEL", line 2
ORA-04088: error during execution of trigger 'SCOTT.STATEMENT_LEVEL'
|
|
|
|
|
|
| trigger fundamental. [message #253763 is a reply to message #253759] |
Tue, 24 July 2007 15:30  |
madhu_msinus@yahoo.co.in
Messages: 12
Registered: July 2007
Location: usa
|
Junior Member |
|
|
hi,
i am new to pl/sql...here i wrote a trigger..but i wants to display the 'vmsg'..what is the condition to display that....i updated one row but i want to display 'statement level trigger fired'..what is the condition...
SQL> create or replace trigger statement_level
2 before update on orders
3 declare
4 vmsg varchar2(30):='statement level trigger fired';
5 begin
6 dbms_output.put_line(vmsg);
7 end satement_level;
8 /
Trigger created.
SQL> update orders set somecolumn = 'xyz';
1 row updated.
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
