In correct date format

[orajit]

Could you Please tell me how to handle incorrect date format exception in pl sql exception section.

[debasisdas]

how are you passingthe date ?

[orajit]

date format is
eg:- to_date('121220 08','ddmmyyyy')

If there is some error in date formate means month,date or complete date format is not proper then it should give me an error.

My query is how to handle that exception in Exception block.

Thanks in advance.

[debasisdas]

Capture the error number and handle that using PRAGMA EXCEPTION_INIT