Q
Problem solve Get help with specific problems with your technologies, process and projects.

Viewing the ORA error in the Windows envionment

How can I view the ORA error in Windows 2000 environment. In Unix, I would have typed (oerr ora-0----) at the $ prompt.

There is not an equivalent utility for the Windows environment to oerr.

But...you can do this in SQL*Plus:

SQL> set serveroutput on
SQL> exec dbms_output.put_line( sqlerrm( -1422 ) );
ORA-01422: exact fetch returns more than requested number of rows

For More Information


Dig Deeper on Oracle error messages

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide.com

SearchDataCenter

SearchContentManagement

SearchHRSoftware

Close