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

807557 
"ld: warning: file /opt/mysql/mysql/lib/libmysqlclient.a(libmysql.o): wrong ELF class: ELFCLASS64
Usually this kind of error is an indication that both 32- and 64-bit object files are being used in building the application. Use all 32-bit objects or 64-bit objects - please do not mix them during compilation.
--

If building from scratch is not mandatory for you, you can try installing postfix {and other applications, libraries, ..} with the help of Blastwave's 'pkg-get'. Some instrustions are at: http://technopark02.blogspot.com/2005/06/solaris-installing-appspackages-with.html 
% pkg-get -a | grep postfix
             postfix 2.2.8,REV=2006.03.13
1 - 1

Post Details

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