OraFAQ Forum: Reports & Discoverer » %p a special reserved character set?

Home » Developer & Programmer » Reports & Discoverer » %p a special reserved character set?

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

%p a special reserved character set? [message #161879]

Tue, 07 March 2006 12:24

tllocke
Messages: 22
Registered: March 2006

Junior Member

I'm trying to build a report that accepts a parameter for an organization name, allowing the user to use the wildcard '%'. If the user searches for an organization starting with 'P', hense entering '%petro%' for example, the parameter gets cut off and displays 'etro%'. Anyone have any suggestions around this? Only happens with '%p'. Thanks.

TL

Report message to a moderator

Re: %p a special reserved character set? [message #162040 is a reply to message #161879]

Wed, 08 March 2006 05:54

kiran
Messages: 503
Registered: July 2000

Senior Member

I just tried in SQL for "%p" it works for me.So there should be some wrong in the way that you are capturing the user parameter(just guessing).

Please check if you can post your code , which will help us to understand more about the issue.

--Kiran.

Report message to a moderator

Re: %p a special reserved character set? [message #162071 is a reply to message #162040]

Wed, 08 March 2006 09:56

tllocke
Messages: 22
Registered: March 2006

Junior Member

Sure... the only reference I have to the parameter is in my "WHERE" statement:

WHERE
(
(
:P_ORG_INST is null and
upper(ORGANIZATION.ORG_NAME) like upper(:P_ORG_SEARCH)
) or (
:P_ORG_INST= ORGANIZATION.ORGANIZATION_INST and
:P_BATCH = CA_NWT_FISCAL.PAYMENT_BATCH_NUMBER
)
) and

Pretty simple I thought. Any help is appreciated. Just doesn't make sense that every other alphabet works!? Stumped.

TL

Report message to a moderator

Re: %p a special reserved character set? [message #162073 is a reply to message #162040]

Wed, 08 March 2006 10:00

tllocke
Messages: 22
Registered: March 2006

Junior Member

Also, if it matters, I'm using Report Builder 9.0.4.0.33 and Oracle 10g db. Thanks again...

Report message to a moderator

Previous Topic:	Whether Report printed or not
Next Topic:	Creating character mod reports

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Sep 18 21:52:19 CDT 2025