SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

SQLERRM

700889Jan 20 2010 — edited Jan 20 2010

Hi,
I am new to oracle and i have a doubt.
sqlerrm is a function which returs the error message of an error code.e.g

begin
dbms_output.put_line(sqlerrm(-1));
end;

ORA-00001: unique constraint (.) violated

but when i do the same thing with sql query it gives me error.

select sqlerrm(-1) from dual;

ORA-00904: "SQLERRM": invalid identifier

Please help me to explain the problem.

Thanks

Locked Post

New comments cannot be posted to this locked post.

Locked on Feb 17 2010

Added on Jan 20 2010

4 comments

3,802 views