| need to retrieve info message from query [message #38087] |
Mon, 18 March 2002 22:38  |
MarcoC
Messages: 10
Registered: February 2002
|
Junior Member |
|
|
Hi,
Does anybody know how to get hold of the strings that informs you on how a sql statement has gone? (See arrows).Thanks
Marco
SQL> insert into temp values(55)
2 /
Created 1 row. <------------
SQL> insert into scott.dept values(50,RAGGIRI,TORINO)
2 /
insert into scott.dept values(50,RAGGIRI,TORINO)
*
ERRORE alla riga 1: <-----------
ORA-00984: colonna non consentita in questo caso <--------
|
|
|
|
| Re: need to retrieve info message from query [message #38093 is a reply to message #38087] |
Tue, 19 March 2002 00:42  |
pratap kumar tripathy
Messages: 660
Registered: January 2002
|
Senior Member |
|
|
ur problem is not clear can u explain little bit more
ORA-00984 column not allowed here
-----------------------------------------
Cause: A column name was used in an expression where it is not permitted, such as in the VALUES clause of an INSERT statement.
Action: Check the syntax of the statement and use column names only where appropriate.
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
