Oracle - default_where in oracle forms

Posted on 2014-09-19
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');

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

'procedure_id = v_poch_procedure_id
Question by:anumoses
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
LVL 74

Accepted Solution

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

Author Comment

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

Expert Comment

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

Author Comment

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

Expert Comment

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.

Featured Post

Free learning courses: Active Directory Deep Dive

Get a firm grasp on your IT environment when you learn Active Directory best practices with Veeam! Watch all, or choose any amount, of this three-part webinar series to improve your skills. From the basics to virtualization and backup, we got you covered.

Question has a verified solution.

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

Note: this article covers simple compression. Oracle introduced in version 11g release 2 a new feature called Advanced Compression which is not covered here. General principle of Oracle compression Oracle compression is a way of reducing the d…
When it comes to protecting Oracle Database servers and systems, there are a ton of myths out there. Here are the most common.
This video shows setup options and the basic steps and syntax for duplicating (cloning) a database from one instance to another. Examples are given for duplicating to the same machine and to different machines
Via a live example, show how to restore a database from backup after a simulated disk failure using RMAN.
Suggested Courses

623 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