Uderc programming article aggregator sites

How to problem solve adf issue in the mx340 model

Answers: Have 2 answers
how to problem solve adf issue in the mx340 model
The best answer: Alex,
the missing thing in your example is the fact, that if only one value is selected, the parameter has exact this value like BOSTON. If you choose more than one value, the parameter includes the *'*, so that it looks like *'BOSTON','NEW YORK'*. So you need to check in the package, if there's a *,* in the parameter or not. If yes there's more than one value, if not it's only one value or it's null.
So change your package to (you need to expand your variables)
create or replace package bip_departments_2_parameters
p_dep_2_param varchar2(1000);
p_loc_1_param varchar2(1000);
p_where_clause varchar2(1000);
function beforereporttrigger
return boolean;
end bip_departments_2_parameters;
create or replace package body bip_departments_2_parameters
function beforereporttrigger
return boolean
l_return boolean := true;
p_where_clause := ' ';
if p_dep_2_param is not null then
if instr(p_dep_2_param,',')>0 then
p_where_clause := 'WHERE DNAME in ('||p_dep_2_param||')';
p_where_clause := 'WHERE DNAME = '''||p_dep_2_param||'''';
end if;
if p_loc_1_param is not null then
if instr(p_loc_1_param,',')>0 then
p_where_clause := p_where_clause || ' AND LOC IN ('||p_loc_1_param||')';
p_where_clause := p_where_clause || ' AND LOC = '''||p_loc_1_param||'''';
end if;
end if;
if p_loc_1_param is not null then
if instr(p_loc_1_param,',')>0 then
p_where_clause := p_where_clause || 'WHERE LOC in ('||p_loc_1_param||')';
p_where_clause := p_where_clause || 'WHERE LOC = '''||p_loc_1_param||'''';
end if;
end if;
end if;
return (l_return);
end beforereporttrigger;
end bip_departments_2_parameters;
I've written a similar example at http://www.oracle.com/global/de/community/bip/tipps/Dynamische_Queries/index.html ... but it's in german.


Related articles

Problem solving code issue

Can anybody explain what is support for ADF Project and to solve the Issues

I am not able to launch FF everytime i tr to open it, it says FF has to submit a crash report, i even tried doing that and the report was submitted too, but stiil FF did not start, and the problem still persists, please help me solve this issue in English

TS1702 I have problem with accessing to my Game Center. I was not able to log in to y game center. The loading took anyone ever had this problem? How do I solve this issue?

TS1363 My iPod Nano 7th Generation couldn't be detected by iTunes when I plugged in. I tried resolving the issue by uninstalling the iTunes and then install it back again but yet still the same problem exist. Can you please help me to solve this issue?

Hello to everyone : I have a problem every time I try to open iTunes for windows 8 64bit... Program stops to work every time trying to access to the store... Is anyone able to help me to solve this issue? Thank you so much...

Hi i got a mac mini but when i connect it to my smartax mt882 modem via ethernet it says device not connected can anyone solve this issue it work fine with the usb connection but the ethernet is giving me problems plz help

I updated my iPhone 4S to the new IOS 6 I like it but the problem I found the Wifi button it's not working any more it looks hidden , so what I should do to solve this issue ASAP

The maximum SOUND level is low on iPad mini retina, compared to an iPhone 4s. Research shows this is a common problem for this model around the world. Has anyone succeeded in solving this issue? Many Thanks, Peter.

My iTunes match on my MacBook Pro hasn't worked since Mountain Lion install. Tried Apple Tech but all their suggestions didn't solve the issue. Guess I will try them again on Monday. Clearly this is a common problem and a Mountian Lion conflict issue.

Recommended article

Snooze problem since software update on N95

I am having a terrible time trying to convert my Quick Time file to an AVI file to use in a powerpoint presentation.  Any suggestions?  I am getting Error .43 file not found?

PDF's opening in Internet Explorer 7 but are unreadable

What about session memory when using BEA Weblogic connection pooling?

IPhoto Book, Page Formats

Hyperion Reports unable to connect to HFM

The cooling fan is strangely noisy

Meta deta repository

Cant Download TV show that I have a subscription to

Including downloadable files in iWeb