Home » SQL & PL/SQL » SQL & PL/SQL » with clause query (oracle 10g,, windows 2003 server)
with clause query [message #356685] Sat, 01 November 2008 00:39 Go to next message
Messages: 100
Registered: September 2008
Senior Member

hi experts

I have a problem , when i execute the following query
its return the following error ..

is it possible to execute "with clause query" in 10g

Database version is -

SQL> ed
Wrote file afiedt.buf

1 WITH q AS (SELECT dummy FROM dual)
2* SELECT dummy FROM q
SQL> /
SQL*Plus internal error state 2091, context 0:0:0
Unsafe to proceed
when execute in toad-9
it return

SQL statement doesn't return rows

thanks in advance
Re: with clause query [message #356694 is a reply to message #356685] Sat, 01 November 2008 02:39 Go to previous messageGo to next message
Michel Cadot
Messages: 65090
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Please read OraFAQ Forum Guide, especially "How to format your post?" section.
Make sure that lines of code do not exceed 80 characters when you format.
Indent the code (See SQL Formatter) and align the columns in result.
Use the "Preview Message" button to verify.

Also always post your Oracle version (4 decimals).

SQL> WITH q AS (SELECT dummy FROM dual)
  2  SELECT dummy FROM q
  3  /

1 row selected.

Use SQL*Plus and copy and paste the whole session including SQL*Plus header and result of "select * from v$version".

Re: with clause query [message #356698 is a reply to message #356685] Sat, 01 November 2008 02:48 Go to previous message
Messages: 1574
Registered: May 2005
Location: Bangalore , India
Senior Member

Same Problem here also


Previous Topic: Help!!!!...Error with a Simple Cursor
Next Topic: BULK COLLECT LIMIT generate ORA-01401
Goto Forum:

Current Time: Thu Jul 27 23:53:36 CDT 2017

Total time taken to generate the page: 0.18216 seconds