OraFAQ Forum: Forms » How to handle data from multiple select boxes in pl/sql?

Home » Developer & Programmer » Forms » How to handle data from multiple select boxes in pl/sql?

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

How to handle data from multiple select boxes in pl/sql? [message #303974]

Mon, 03 March 2008 09:35

hedonist123
Messages: 119
Registered: August 2007

Senior Member

Hi,

I have to write a procedure to return a set of values depending on inputs provided.

However, in this case the input shall be in form of comma separated values.

For e.g. there is a multiple select box called colour on the UI, so the person can select multiple colours and its gets passed as 'Blue','Green','White'.

Now, I have to return all the records from a table where colour in ('Blue','Green','White').

How do I handle this? I mean it is passed as a variable pcolor to the SP.

How do I analyse this variable and extract the colors so I could compare it with the table and retrieve records?

Thanks,

Sharath

Report message to a moderator