I need to try to decrypt a column and IF it errors out then try another decryption method.

Hi,

As mentioned in the subject.

I have a function called decrypt. it takes a decrypt method between 0 and 3 and a value (raw).
If it fails to decrypt, it returns this:

ORA-01465: invalid hex number

01465. 00000 -  "invalid hex number"

*Cause:   

*Action:

Is there a way to write some code where I can try all 4 different methods (if the first one fails then elseif the 2nd method doesn't work etc... and if none work, then assume it's decrypted and read the data as is).

So far it looks like I can only identify the error using PRAGMA EXCEPTION_INIT and use exception handler from the BEGIN...END block.