Home » Developer & Programmer » Forms » "IN" Clause
"IN" Clause [message #249904] Fri, 06 July 2007 08:29 Go to next message
ora_dev
Messages: 27
Registered: December 2006
Junior Member
I have a Forms 6i application.

I build values into a character field (length 50). I separate each value by a comma. Field name is P_VALUES.


If I do a select from this field the values returned would look something like this: 10,25,23,24,50.

In a program unit I have the following code in a cursor:

select district_name
from all_districts
where district_code in :TEMP_BLOCK.P_VALUES;

The code does not return any values. I have verified that I have valid district codes. Is there any other way to retrieve these values.

Thanks






Re: "IN" Clause [message #249907 is a reply to message #249904] Fri, 06 July 2007 08:37 Go to previous message
ora_dev
Messages: 27
Registered: December 2006
Junior Member
Problem resolved, I used the INSTR function.
Previous Topic: WEB_UTIL installation
Next Topic: Using Numeric Keypad in Oracle Forms
Goto Forum:
  


Current Time: Mon Dec 05 15:13:59 CST 2016

Total time taken to generate the page: 0.07700 seconds