Home » Developer & Programmer » Reports & Discoverer » Numeric OR value error in After param
Numeric OR value error in After param [message #280330] Tue, 13 November 2007 04:37 Go to next message
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 Go to previous messageGo to next message
Littlefoot
Messages: 20891
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.
icon12.gif  Re: Numeric OR value error in After param [message #280367 is a reply to message #280330] Tue, 13 November 2007 06:04 Go to previous messageGo to next message
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
Re: Numeric OR value error in After param [message #280385 is a reply to message #280367] Tue, 13 November 2007 06:40 Go to previous message
musman
Messages: 147
Registered: July 2007
Location: Lahore
Senior Member

thanks that was length problem..
it`s working.
Previous Topic: problem in Report builder
Next Topic: i need one parameter to display either all the cases or restrict one
Goto Forum:
  


Current Time: Sat Dec 03 14:25:21 CST 2016

Total time taken to generate the page: 0.04782 seconds