Home » SQL & PL/SQL » SQL & PL/SQL » order by clause in select into
order by clause in select into [message #247690] Tue, 26 June 2007 21:27 Go to next message
yog_23
Messages: 79
Registered: March 2007
Member
Is this not allowed ?

Or is this a bug.

When I add a order by clause in a select into statement it throws the following error :

"ORA - 00932 Inconsistent datatype: expected - got CURSER "

This is the error message I get.

Thank you
Yog

Re: order by clause in select into [message #247691 is a reply to message #247690] Tue, 26 June 2007 21:34 Go to previous messageGo to next message
BlackSwan
Messages: 25039
Registered: January 2009
Location: SoCal
Senior Member
Since you chose to not follow the posting guidelines, I choose to NOT answer.

You're On Your Own(YOYO)!

[Updated on: Tue, 26 June 2007 22:22] by Moderator

Report message to a moderator

Re: order by clause in select into [message #247716 is a reply to message #247690] Wed, 27 June 2007 00:03 Go to previous messageGo to next message
Frank
Messages: 7880
Registered: March 2000
Senior Member
yog_23 wrote on Wed, 27 June 2007 04:27
Is this not allowed ?

"ORA - 00932 Inconsistent datatype: expected - got CURSER "


LOL
No, cursing is not allowed.

How can we help you if you don't provide any code?
Re: order by clause in select into [message #247718 is a reply to message #247690] Wed, 27 June 2007 00:13 Go to previous message
BlackSwan
Messages: 25039
Registered: January 2009
Location: SoCal
Senior Member
>How can we help you if you don't provide any code?
Everyone knows that those who provide answers here don't need to see code to actually debug SQL.
We (TINW) are assumed to be mind readers & grok the unposted SQL

Do you mean you can't fix SQL based only upon error code?
I'm disappointed.
Previous Topic: Oracle query for date of the week
Next Topic: Problem while calling a function in SQL
Goto Forum:
  


Current Time: Mon Dec 05 21:37:16 CST 2016

Total time taken to generate the page: 0.07594 seconds