Solved

Oracle - default_where in oracle forms

Posted on 2014-09-19
5
261 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 73

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 73

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 73

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

Zoho SalesIQ

Hassle-free live chat software re-imagined for business growth. 2 users, always free.

Question has a verified solution.

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

Suggested Solutions

Subquery in Oracle: Sub queries are one of advance queries in oracle. Types of advance queries: •      Sub Queries •      Hierarchical Queries •      Set Operators Sub queries are know as the query called from another query or another subquery. It can …
Checking the Alert Log in AWS RDS Oracle can be a pain through their user interface.  I made a script to download the Alert Log, look for errors, and email me the trace files.  In this article I'll describe what I did and share my script.
This video shows how to copy a database user from one database to another user DBMS_METADATA.  It also shows how to copy a user's permissions and discusses password hash differences between Oracle 10g and 11g.
This video shows how to configure and send email from and Oracle database using both UTL_SMTP and UTL_MAIL, as well as comparing UTL_SMTP to a manual SMTP conversation with a mail server.

896 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

Need Help in Real-Time?

Connect with top rated Experts

17 Experts available now in Live!

Get 1:1 Help Now