How to add exception in given below query [message #529894] |
Thu, 03 November 2011 09:28 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
qanita786
Messages: 229 Registered: May 2007 Location: PAKISTAN
|
Senior Member |
|
|
when no data found this query generate error ora-01403 but if i count these transaction and then apply this trigger it works very well i am not intrested to count because it takes a time i want that when no data found exception clause took control but i am not understand how to add exception clause in this trigger
select sum(nvl(gl_quantity,0)),sum(nvl(gl_amount,0)) into cr_qty,cr_amt from account.glhis where gl_drcr='CR' and gl_account=:prod_consume_auto.store_code and gl_date<=:prod_master_auto.voc_date and gl_voc_no<>:prod_master_auto.voc_no group by gl_account;
Regards
|
|
|
|
|
|