| srw.do_sql [message #90395] |
Sun, 13 February 2005 02:49  |
Satya
Messages: 36
Registered: January 2001
|
Member |
|
|
I am using reports 6i.I am inserting some rows in a table based on the input parameter in the after parameter trigger.
After that I am writing one pl/sql to update the columns based on some conditions.(in the same after param trigger)
to update some rows and quering it.
while compiling it doesnt show any error.
but when i am running it ,it shows up with the error
ORA ERROR 1722 and rep 1401.
but the pl/sql is working fine on TOAD
satya
|
|
|
|
| Re: srw.do_sql [message #117211 is a reply to message #90395] |
Mon, 25 April 2005 14:52  |
Gurusubramanyam
Messages: 79
Registered: July 2001
|
Member |
|
|
Dear Sathya,
If you are doing only DML then better write a local procedure or a database procedure and do it inside the procedure so that you can call that procedure in the after parameter form trigger.
I feel, if you are using any DDL's or a simple select then SRW.DO_SQL will be a good option.
Thanks & Regards,
G.S
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
