Home » SQL & PL/SQL » Client Tools » Unable to perform operations using 'dual' table: SP2-0575
Unable to perform operations using 'dual' table: SP2-0575 [message #25840] Wed, 21 May 2003 02:49 Go to next message
vivek
Messages: 59
Registered: October 2001
Member
Getting message:
SP2-0575: Use of Oracle SQL feature not in SQL92 Entry Level.
when logging into SQL*Plus

At SQL Prompt, I am unable to perform operations using 'dual' table
Re: Unable to perform operations using 'dual' table: SP2-0575 [message #25844 is a reply to message #25840] Wed, 21 May 2003 05:44 Go to previous messageGo to next message
Maaher
Messages: 7062
Registered: December 2001
Senior Member
I see two possible causes:
1. There's another user who has a DUAL table. If so, rename or drop it. It might conflict with Oracle's internal SQL processing (which might have the form of "SELECT something_something from dual").

If this provides no solution, there's another (less likely) possible cause:
2. Are you sure that DUAL contains a row? Make sure it contains 1 row with the value 'X'. If
SELECT * FROM DUAL;
returns no rows, issue an insert:
INSERT INTO DUAL VALUES('X');
And don't forget to commit.

HTH,
MHE
Re: Unable to perform operations using 'dual' table: SP2-0575 [message #255673 is a reply to message #25844] Wed, 01 August 2007 08:22 Go to previous messageGo to next message
amul
Messages: 252
Registered: April 2001
Location: Chennai
Senior Member
Am not able to connect to this database,please help am using oracle version 8i,connecting to 10G database


SQL> conn
Enter user-name: didev
Enter password: **************
ORA-24323: value not allowed
Error accessing package DBMS_APPLICATION_INFO
ERROR:
ORA-03113: end-of-file on communication channel


SP2-0575: Use of Oracle SQL feature not in SQL92 Entry Level.
ORA-24323: value not allowed
Connected.
SQL> select * from tab;
select * from tab
*
ERROR at line 1:
ORA-03114: not connected to ORACLE


SQL> show user
USER is "DIDEV"
SQL> select * from dual;
select * from dual
*
ERROR at line 1:
ORA-03114: not connected to ORACLE
Re: Unable to perform operations using 'dual' table: SP2-0575 [message #255704 is a reply to message #255673] Wed, 01 August 2007 09:25 Go to previous message
ThomasG
Messages: 3189
Registered: April 2005
Location: Heilbronn, Germany
Senior Member
Oracle 8 client connections to Oracle 10 servers are not supported anymore.

There are also a number of bugs in that area, which would be dependend on the EXACT oracle version (4 digits)

Update the client, I would say.

[Updated on: Wed, 01 August 2007 09:25]

Report message to a moderator

Previous Topic: How to execute a .sql file in sqlplus editor ?
Next Topic: query hang on toad
Goto Forum:
  


Current Time: Sat Dec 10 20:31:08 CST 2016

Total time taken to generate the page: 0.05170 seconds