Forum Stats

  • 3,875,533 Users
  • 2,266,940 Discussions
  • 7,912,242 Comments

Discussions

Clarify docs: "A SQL statement cannot invoke SQLERRM"

User_1871
User_1871 Member Posts: 247 Red Ribbon

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]

Idea: 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?

User_1871
1 votes

Active · Last Updated