Home » SQL & PL/SQL » SQL & PL/SQL » Use of Case Statement (Oracle 8i,Windows)
Use of Case Statement [message #282650] Thu, 22 November 2007 21:43 Go to next message
jibusj
Messages: 1
Registered: November 2007
Junior Member
I want to use case statement in procedure by using oracle 8i.Is it possible to use case statement inside the pl/sql in oracle 8i?
If not what is other solution to use case stament inside the procedure in oracle 8i version?

I want to use attach query inside the procedure in oracle 8i.When i tried i got error like "Encountered symbol 'CASE' when expecting one of the following....

Please give me one solution for this


Thanks
Jibu
Re: Use of Case Statement [message #282660 is a reply to message #282650] Thu, 22 November 2007 22:35 Go to previous messageGo to next message
BlackSwan
Messages: 25050
Registered: January 2009
Location: SoCal
Senior Member
>Please give me one solution for this
Upgrade to at least V9.2.0.8
Re: Use of Case Statement [message #282681 is a reply to message #282660] Fri, 23 November 2007 00:16 Go to previous message
Littlefoot
Messages: 20901
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Or switch back to DECODE, if possible.
Previous Topic: A Syntax issue, whats wrong?
Next Topic: Executing Procedure
Goto Forum:
  


Current Time: Sat Dec 10 03:23:35 CST 2016

Total time taken to generate the page: 0.04861 seconds