CASE function is not working

Advertisement

Hi,
I want to use the CASE function in a sql statement used at form level but it's not working. I can't compile the form. I am using developer 6i at font end and Oracle 10g database at back end. Is it possible to use case function at form level sql statement. If so then please help me about it.
Best Regards

Advertisement

Forms has it's own PL/SQL engine, and in Forms 6i it's version 8 where no CASE was available. So if you want to use CASE you'll have to use a view or put your logic in a stored procedure.

October 11, 2015

CASE function is not working

Hi, I want to use the CASE function in a sql statement used at form level but it's not working. I can't compile the form. I am using developer 6i at font end and Oracle 10g database at back end. Is it possible to use case function at form level sql s

HT201335 when using apple tv with my ipad, the mirroring function does not work, screen goes black, what is the issue?

when using apple tv with my ipad, the mirroring function does not work, screen goes black, what is the issue?  My son's Ipad(same as kind as mine) works ok with the apple tv but mine does not.  Any suggestions?Hello Nina Izurin, While written for the

Function Module not working for old Role

Dears Function Module not working for old Role Function Module: /VIRSA/BAPI_AE_USERS_FOR_ROLES Before EHP4 upgrade this functional module working fine, but after updated users are not visible. We have chekced if the users are assigned directly users

Autofill function is not working, 'window' sticks through it not functional!

autofill function is not working, 'window' sticks through it not functional!Back up all data, then test after each of the following steps that you haven't already tried. Stop when the problem is resolved. 1. Quit and relaunch Safari. 2. Select your c

After upgraded ios6 i got problem with whatapp. "last seen" function is not working

HI eveyone after upgraded ios6 i got problem with whatapp. "last seen" function is not working .. it's doest show last seen who enter the chat . is anyone have the same problem .. i even restore and reinstall to my ph but it's  not work .. if so

Radio button and associated functionality is not working!

Hi Pros, I am facing the following problem: 1.I have an interactive PDF created in Acrobat 9 Pro. 2.PDF have few radio buttons, each radio buttons ahave assigned valus(eg: 1,2,3 etc) 3.I have a text box in which the value of selected radio button is

The auto lock function is not working on the iphone 3gs running ios 6...what should i do?

the auto lock function is not working on the iphone 3gs running ios 6...what should i do?Temporary fix - turn off assistive touch if you happen to have it on.Read other 2 answers

My search function does not work. How can I fix it?

Hello I need help I just bough a macbook 13 inch, with snow leopard and the search function does not work. The window opens but when I write the name i searh it gives me no results. How can i fix it? Do i need really to re install all snow leopard? t

Crystal Report for VS2010 - The Go To Page function does not work

When running a report into Crystal(VS2010), the Go To Page function does not work.  Typing in a page number and pressing Enter does not take you to that page.  The report remains on the current page. I'm not sure if there is suppose to be a button li

Push function is not working

Hi The Mail push function is not working properly. Sometimes it works for a couple of day, sometimes it is not working anymore. Do anybody know a solution for this? Thanks,Make sure you have ticked the Tap to Click option under Trackpad in your Syste

G510 installed Windows 8.1 Function keys not working properly

Hi  I am Bharath last week i have puchased lenovo g510 laptop and installed windows 8.1 and later on automatically function keys and all the keys were not working properly. if i press key to increase brightness and some other operation is performing

Binding to a javascript function is not working

I am trying to use the following code to bind to a javascript function and it's not working. I finally had to use jQuery to bind the event handler, but I would like to see the CF generated stuff work. Am I missing something here? This jquery code is

Special Functions keys not working on Satellite C50 - Windows 8.1

Hello, Please could someone help me out. I have a Toshiba Satellite C50-A0393 that I got a few months ago with Windows 8.1 already installed (64 bit). Today I got a message saying I needed to look at the PC Health, a Toshiba blue message concerning t

Greater function(Arithmetic) not working in graphical mapping

Hi SapAll. in an Idoc To File Interface i have got a requirement where i need to compare occurance of two child segments  G02,G02 Under parent Segment G01 and then determine the occurance of target Record Structure. the IDOC structure is   G01       

Function Module not working through VC

Hi Experts I am facing one strange issue while working on VC model with function module as data service. This FM is to writes data to bcak end BI master data table which is working fine through BI. When i pass the values through VC, New values are no

Preflight InDesign function/panel not work

I have updated Indesign to the last update of CC 2014 ITALIAN language, and the preflight (verifica preliminare) function, has stopped working from one day to another! Both new documents and on documents from older versions of Creative Suite, Preflig

New Apple Wireless Keyboard Function Key not working ON 10.5.8

Tried updating keyboard os, disconecting reconnecting. Selecting/deselecting option in keyboard options.  power off and on Cannot get function key to work Thanksfound answer here- my wireless keyboard model is  MC184LL/B http://store.apple.com/us/que

HT1192 caps lock function does not work after latest update

Hi there, I have a Macbook 13" Early 2011 and recently after updating my operating system to Mac OS X 10.7.4, i have found that the caps lock button isn't functioning. At present if i hold or press the button, it is failing to light up or function at

Abs Function is not working for converting the negitive valies

Hi ,    My requirement is from the sorce I'm getting Amount data (both negative and possitive values) if the value is negative then i want to convert it as possitive value. that means always i want to pass possitive values to my target side. For this

Case when then not working

In my database, two variable ID and time (varchar2) are there. I want to populate another variable using case when then by putting below conditon to convert like this But its not working. Can anyone help me if time =1 day then '1 Day' time > 2 days a