To add :

check this code
IF SUBSTR(V_EVENTDATADESC,7,9) = '019000000' THEN V_APPLICATIONDBOID := TO_NUMBER(SUBSTR(V_EVENTDATADESC,7)); END IF;

i dunno wasss ur Program Logic....but certainly if V_APPLICATIONDBOID has non numeric value then it errors...


Do one thing....output all the fields in exception part....u will get the answer....( it wud be easy to debug )


Abhay.