 Insert problem on 10g? [message #140141] |
Sat, 01 October 2005 06:09  |
NewEra
Messages: 3
Registered: October 2005
|
Junior Member |
|
|
imported an Oracle 8 database into 10g, but cannot insert into 1
of the tables.
User has roles :
create session
connect
resource
does user need other roles to do insert?
how can I view table specific priviledges?
Thank you
[Updated on: Sat, 01 October 2005 06:16] Report message to a moderator |
|
|
|
|
|
| Re: Insert problem on 10g? [message #140163 is a reply to message #140144] |
Sat, 01 October 2005 13:15  |
NewEra
Messages: 3
Registered: October 2005
|
Junior Member |
|
|
ORA-00984: column not allowed here
That's the error message I get.
Searching on the internet, I find this :
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.
But I checked the table and the insert statement and the column names match. The code runs without problems on Oracle 8, but moving the data to 10g, now I get the error.
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
