| "IN" Clause [message #249904] |
Fri, 06 July 2007 08:29  |
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
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
