OraFAQ Forum: Forms » Passsing parameters in where .. in ( ) clause

Home » Developer & Programmer » Forms » Passsing parameters in where .. in ( ) clause

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

Passsing parameters in where .. in ( ) clause [message #81589]

Tue, 04 March 2003 11:19

Felix Murillo
Messages: 2
Registered: March 2003

Junior Member

My report is based on a table from which I want to filter a few records based on the passing emp. codes.
I am calling the report from the form itself. This form contains a grid that selects the codes. The codes are passing to the report in a varchar variable, ex: ('890-A','900-B'). The select "select sob_numexp from tfsvsoloblig
where sob_numexp :ex_where" fails if it passed more than one value.

Report message to a moderator

Re: Passsing parameters in where .. in ( ) clause [message #81590 is a reply to message #81589]

Tue, 04 March 2003 11:20

Felix Murillo
Messages: 2
Registered: March 2003

Junior Member

The select is:
select sob_numexp from tfsvsoloblig
where sob_numexp in (:ex_where).

Report message to a moderator

Previous Topic:	Delete Button
Next Topic:	Forms TO Oracle Apps 10.7 - Scroll bar issue

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Apr 26 03:26:05 CDT 2024