Skip to Main Content
Forums

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

How to pass multiple parameters to a bind variable in a query with = sign ?

msFeb 8 2022 — edited Feb 8 2022

Hi Everyone,

The user will select multiple pick value from screen like 100, 101, 102 etc
and those values need to be passed to the below query and generate the
o/p for further processing.
Can some one please tell how can i pass multiple values to a bind parameter in a query having a equal to sign?

SELECT tab1.PICKLIST_KEY icrggq_0, NULL icrggq_1, 0 icrggq_2
FROM tab1
WHERE dc_code = 942
AND tab1.pick_value = :p_pick_value;

There are hundereds of queries like this and we will not be able to modify all of them manually.
Is it possible to be done by plsql procedure or function ?
We are receving the multiple values through front end Oracle Forms screen.

Thanks
Gautam
This post has been answered by BluShadow on Feb 8 2022
Jump to Answer

Comments

Processing

Post Details

Added on Feb 8 2022
#19-3-3, #query
4 comments
6,962 views
1 mention