PL/SQL Question:exceptions

[jlakhani]

Does anybody know where I can find a list of exceptions? We have developers who have coded these exceptions but i cant figure out what these exceptions mean??

thanks
Jigar

[pando]

tahiti.oracle.com

[Orca777]

Hi,
they are defined in the package SYS.STANDARD :

--***************** Predefined exceptions *****************

  CURSOR_ALREADY_OPEN exception;
    pragma EXCEPTION_INIT(CURSOR_ALREADY_OPEN, '-6511');

  DUP_VAL_ON_INDEX exception;
    pragma EXCEPTION_INIT(DUP_VAL_ON_INDEX, '-0001');

  TIMEOUT_ON_RESOURCE exception;
    pragma EXCEPTION_INIT(TIMEOUT_ON_RESOURCE, '-0051');

...

Orca

[jlakhani]

Pando,
can you pls be more specific?

thanks