Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Oracle - default_where in oracle forms

Posted on 2014-09-19
5
Medium Priority
?
290 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
  • 3
  • 2
5 Comments
 
LVL 74

Accepted Solution

by:
sdstuber earned 2000 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

New feature and membership benefit!

New feature! Upgrade and increase expert visibility of your issues with Priority Questions.

Question has a verified solution.

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

I'd like to talk about something that is near and dear to my heart: build systems. Without them, building software is all about compiling locally, with software versions everywhere. It can be a mess. Today we are going to discuss building a small di…
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 explains what a user managed backup is and shows how to take one, providing a couple of simple example scripts.
This tutorial explains how to use the VisualVM tool for the Java platform application. This video goes into detail on the Threads, Sampler, and Profiler tabs.
Suggested Courses

926 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