| unable to perform query ORA40505 [message #53899] |
Wed, 16 October 2002 10:56  |
rajitha
Messages: 19
Registered: July 2002
|
Junior Member |
|
|
|
I created some tables in scott's schema and then by looging in as system&manager,i created some new users and granted select,create session,resource,insert etc privileges to these users.Though these users are able to log in ,they are unable to perform any query or DML.why this problem occurs?pls.help!!
|
|
|
|
|
|
| Re: unable to perform query ORA40505 [message #53905 is a reply to message #53899] |
Wed, 16 October 2002 16:24  |
Trifon Anguelov
Messages: 514
Registered: June 2002
|
Senior Member |
|
|
You are having some syntax error in your Forms code. Check your code one more time.
Also, you can go to "Display Error" screen at the runtime of the Forms to see how exactly the query is interpretted. It's easy to see if there is a error with the SQL parsing this way.
Hope that helps,
clio_usa
OCP - DBA
Visit our Web site
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
