Skip to Main Content

Oracle Database Discussions

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!

Clarify docs: "A SQL statement cannot invoke SQLERRM"

User_1871Jun 8 2022 — edited Jun 8 2022

The 21c docs say:
13.63 SQLERRM Function
SQLERRM()
A SQL statement cannot invoke SQLERRM.
Are the docs suggesting we can't use SQLERRM() in a SELECT query?
If so, that seems incorrect:

SELECT SYS.STANDARD.SQLERRM(-1422) FROM DUAL;

--That query works as expected:

SYS.STANDARD.SQLERRM(-1422)
-----------------------------------------------------------------
ORA-01422: exact fetch returns more than requested number of rows

[1 row selected]

image.pngIdea: Could the docs be improved so that it's clear that we can use SQLERRM() in a SELECT query?
Related: Are certain kinds of Oracle functions only available in PL/SQL, not SQL?

Comments

Post Details

Added on Jun 8 2022
0 comments
126 views