This content has been marked as final. Show 4 replies
Ghulam Yassen wrote:As salamualikum Ghulam Yassen,
FRM-40735:POST-CHANGE-trigger raised unhandled
Data Types of
:ACC_ISSUE_C.SIZE_CODE [VARCHAR2(5) ]
AND :ACC_ISSUE_C.COLOUR_CODE [ VARCHAR2(7) ]?
The error code says
You can use Exception to handle this. For example
ORA-01403: no data found
Hope this helps...
begin ...... Your code ................ EXCEPTION WHEN NO_DATA_FOUND THEN :ACC_ISSUE_C.BALANCE=0; END;
and thanks for your Idea.
actually I no need to return 0 i want to calculate balance of all all items which size_code is null too.
so I solved this issue.
i simply create additional field(size_code to size_code_v) and at post-query trigger(data block level)
i set it to 0 if it is null , doing so I calculate balance of those items too who's size_code is null.