OraFAQ Forum: Client Tools » Unable to perform operations using 'dual' table: SP2-0575

Home » Other » Client Tools » Unable to perform operations using 'dual' table: SP2-0575

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Unable to perform operations using 'dual' table: SP2-0575 [message #25840]

Wed, 21 May 2003 02:49

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

Report message to a moderator

Re: Unable to perform operations using 'dual' table: SP2-0575 [message #25844 is a reply to message #25840]

Wed, 21 May 2003 05:44

Maaher
Messages: 7065
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

Report message to a moderator

Re: Unable to perform operations using 'dual' table: SP2-0575 [message #255673 is a reply to message #25844]

Wed, 01 August 2007 08:22

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

Report message to a moderator

Re: Unable to perform operations using 'dual' table: SP2-0575 [message #255704 is a reply to message #255673]

Wed, 01 August 2007 09:25

ThomasG
Messages: 3212
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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Dec 22 16:19:12 CST 2024