Home » SQL & PL/SQL » SQL & PL/SQL » convert error to a table format (oracle 9i, Windows XP)
convert error to a table format [message #330327] Sun, 29 June 2008 12:20 Go to next message
sdhanuka
Messages: 173
Registered: March 2008
Senior Member
hey when we get an error for example


ERROR:
ORA-12535: TNS:operation timed out
Warning: You are no longer connected to ORACLE.
SP2-0640: Not connected

and display in a table format??
Re: convert error to a table format [message #330330 is a reply to message #330327] Sun, 29 June 2008 13:17 Go to previous messageGo to next message
Michel Cadot
Messages: 64108
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
What do you mean table format?
Anyway, this message is displayed by SQL*Plus and you can't change the format.
But in your application you can display it as you want.

Regards
Michel
Re: convert error to a table format [message #330334 is a reply to message #330330] Sun, 29 June 2008 13:32 Go to previous messageGo to next message
sdhanuka
Messages: 173
Registered: March 2008
Senior Member
in my application as in??
Re: convert error to a table format [message #330338 is a reply to message #330334] Sun, 29 June 2008 14:09 Go to previous messageGo to next message
Michel Cadot
Messages: 64108
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
sdhanuka wrote on Sun, 29 June 2008 20:32
in my application as in??

Question

Regards
Michel

Re: convert error to a table format [message #330339 is a reply to message #330338] Sun, 29 June 2008 14:10 Go to previous messageGo to next message
sdhanuka
Messages: 173
Registered: March 2008
Senior Member
what application are you talking about i meant?
Re: convert error to a table format [message #330341 is a reply to message #330339] Sun, 29 June 2008 14:12 Go to previous messageGo to next message
Michel Cadot
Messages: 64108
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
YOUR application, the one you use, the one you program, the one you're working with.

Regards
Michel
Re: convert error to a table format [message #330342 is a reply to message #330341] Sun, 29 June 2008 14:19 Go to previous messageGo to next message
sdhanuka
Messages: 173
Registered: March 2008
Senior Member
only application i am working with oracle 9i Smile

[Updated on: Sun, 29 June 2008 14:21]

Report message to a moderator

Re: convert error to a table format [message #330378 is a reply to message #330342] Mon, 30 June 2008 00:28 Go to previous message
Frank
Messages: 7880
Registered: March 2000
Senior Member
Why do you want it "in a tabular format" if you are not displaying it in an application?
Previous Topic: Calling procedure from unix shell scripts-URGENT
Next Topic: Parameterized view
Goto Forum:
  


Current Time: Mon Dec 05 04:50:40 CST 2016

Total time taken to generate the page: 0.26021 seconds