Hi All, I am also running the same package but unable to run it from PL SQL. please guide me for the same.when i am running this procedure it gives some error at "raise_application_error(-20001, return_text);" --line num 72 in app_exception package. please help me to run this successfully....