OraFAQ Forum: Reports & Discoverer » Numeric OR value error in After param

Home » Developer & Programmer » Reports & Discoverer » Numeric OR value error in After param

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

Numeric OR value error in After param [message #280330]

Tue, 13 November 2007 04:37

musman
Messages: 147
Registered: July 2007
Location: Lahore

Senior Member

am using reports 6i..

using this code in after parameter form

IF
  	:P_CLIENT='ALL' THEN
  	:CLIENT:=' ';
  ELSE
:CLIENT:='AND (t.buyer IN (select client_code from XYZ where client_code=:P_CLIENT) OR 
t.seller In (select client_code from XYZ where client_code=:P_CLIENT))';

but it giving numeric or value error ora-06502 in else part.
For all it`s running fine.
&CLIENT
is in report query.

[Updated on: Tue, 13 November 2007 04:38]

Report message to a moderator

Re: Numeric OR value error in After param [message #280363 is a reply to message #280330]

Tue, 13 November 2007 06:00

Littlefoot
Messages: 21813
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

How did you declare 'CLIENT'? It should be a CHARACTER, that's obvious, but what is its size? Should be at least 149 characters long, as the string (AND (t.buyer ... ) you are trying to put into is that long.

Report message to a moderator

Re: Numeric OR value error in After param [message #280367 is a reply to message #280330]

Tue, 13 November 2007 06:04

Omar Hattab
Messages: 2
Registered: October 2007
Location: Jordan

Junior Member

hi ;

check the parameter properties for :
data type : character
width : must be more than 150

:CLIENT:='AND (t.buyer IN (select client_code from XYZ where client_code=:P_CLIENT) OR
t.seller In (select client_code from XYZ where client_code=:P_CLIENT))';

this is more than 150

Best Regards

Report message to a moderator

Re: Numeric OR value error in After param [message #280385 is a reply to message #280367]

Tue, 13 November 2007 06:40

musman
Messages: 147
Registered: July 2007
Location: Lahore

Senior Member

thanks that was length problem..
it`s working.

Report message to a moderator

Previous Topic:	problem in Report builder
Next Topic:	i need one parameter to display either all the cases or restrict one

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Jul 03 01:36:01 CDT 2024