Solved

Oracle - default_where in oracle forms

Posted on 2014-09-19
5
268 Views
Last Modified: 2014-09-19
I an using default_where.

SET_BLOCK_PROPERTY('qc_poch_again',default_where,'procedure_id = v_poch_procedure_id and term_date is null and EQUIP_TYPE_ID = :parameter.equip_type_id1 and qc_type_id = :qc_daily.qc_type_id AND qc_subtype_id = :qc_daily.qc_subtype_id');
                   GO_BLOCK('qc_poch_again');               
               EXECUTE_QUERY;


 But wanted to know if I can use procedure_id in (1205,1224)

'procedure_id = v_poch_procedure_id
0
Comment
Question by:anumoses
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
5 Comments
 
LVL 74

Accepted Solution

by:
sdstuber earned 500 total points
ID: 40332842
you should be able to,  but...

if your variable is just a string like '1205,1224'   then it won't work. because it simply looks like a list  but is still only one string
0
 
LVL 6

Author Comment

by:anumoses
ID: 40332855
Yes procedure_id is a number data type.
0
 
LVL 74

Expert Comment

by:sdstuber
ID: 40332875
I don't know what you're trying to tell me.
I was referring to the variable, not the column.
0
 
LVL 6

Author Comment

by:anumoses
ID: 40332934
ok got the answer. So its not possible. Thanks
0
 
LVL 74

Expert Comment

by:sdstuber
ID: 40333402
it should still be possible but not necessarily convenient.  A simple variable substitution won't do it.

Assuming your  v_poch_procedure_id is a string like '1205,1224'

you could use a function to parse the string and turn it into a collection and then do something like this

procedure_id member of (str2tbl(v_poch_procedure))

you can search EE for str2tbl, I've posted code for it several times,  Tom Kyte wrote the original, you could check his site too.
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

How to Create User-Defined Aggregates in Oracle Before we begin creating these things, what are user-defined aggregates?  They are a feature introduced in Oracle 9i that allows a developer to create his or her own functions like "SUM", "AVG", and…
Background In several of the companies I have worked for, I noticed that corporate reporting is off loaded from the production database and done mainly on a clone database which needs to be kept up to date daily by various means, be it a logical…
Video by: Steve
Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…
Via a live example, show how to restore a database from backup after a simulated disk failure using RMAN.

734 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question