OraFAQ Forum: Forms » Oracle Forms - Multiple Values in a Field

Home » Developer & Programmer » Forms » Oracle Forms - Multiple Values in a Field - Question (Forms 12c, Database12c)

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

Oracle Forms - Multiple Values in a Field - Question [message #677128]

Tue, 20 August 2019 17:17

balajiray
Messages: 6
Registered: August 2019

Junior Member

Hi
I am trying t test out adding multiple invoice #'s in one field separated by comma and use that field value
in an in() statement.

Eg:
select * from billing_hist where invoice_number in(:block.item);
I want to add multiple invoice #'s in this field separated by comma and use the query in a cursor to further process the business rules.

I am able to enter one invoice # and make it work. The moment i add the second invoice # it fails.
Any suggestions will be helpful.

regards,
Ray.

Report message to a moderator

Oracle Forms - Multiple Values in a Field - Question [message #677129 is a reply to message #677128]

Tue, 20 August 2019 17:24

balajiray
Messages: 6
Registered: August 2019

Junior Member

Hi

I have to add multiple values in a single field and use that field in the where clause.

select * from bill_hist where invoice_number in(:block.item);

I want to enter multiple invoice #'s in the item field separated by comma's and use that in the query as shown above.
Then i want to use the query in a cursor to further process data.

Is this possible. Please add your suggestions.

regards,
Ray.

Report message to a moderator

Re: Oracle Forms - Multiple Values in a Field - Question [message #677130 is a reply to message #677129]

Tue, 20 August 2019 18:01

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

Welcome to this forum

Please read and follow the forum guidelines, to enable us to help you:
OraFAQ Forum Guide
How to use {code} tags and make your code easier to read

Report message to a moderator