| 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.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
