This content has been marked as final. Show 2 replies
911229 wrote:where you use the cursor ?
i am facing a problem.i hav a master detail form. my 'select into' has to fectch more than one record in detail which is tabular.
it giving error(FRM-40735:WHEN-MOUSE-CLICK TRIGGER raised unhandled exception ORA-01422).
so i had written cursor to fetch records.
it is not retriving any records.please help.i also put ship_mstr.bill_id in properties of ship_dtl.bill_id(copy value)Which one is not retrieving any record ? first one or second one... and
check the sql separately first..
select bill_id,mat_id,mat_code,send_qty,rec_qty,ast_no,serial_no,transact_note from ship_dtl where rec_qty is null AND rec_qty != send_qty AND BILL_ID=:SHIP_MSTR.BILL_ID ---How you pass the value here ? do you give input or any other way ?