Home » Developer & Programmer » Reports & Discoverer » REP-0159 Synatx error on command line
REP-0159 Synatx error on command line [message #276445] Thu, 25 October 2007 03:09 Go to next message
Messages: 56
Registered: September 2007
hello every one

i have oracle 8.1.7 and reports 6.0
my requirement is that i am sending a parameter to reports and after the parameter in input by user in form then i add closing and opening parenthesis in that string i.e


now when i send this :par1 to form there i want to display it in reports but i receive the following error when i run my form and click run_rep button

REP-0159 Syntax Error on command line

i have tried to look for it help and it do say something about brackets and parenthesis but i didn't get it

any one can help

Re: REP-0159 Synatx error on command line [message #276448 is a reply to message #276445] Thu, 25 October 2007 03:28 Go to previous messageGo to next message
Messages: 21146
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Could you show us the whole code, not only ":par1:='('||:par1||')';"?
Re: REP-0159 Synatx error on command line [message #277501 is a reply to message #276445] Tue, 30 October 2007 06:50 Go to previous message
Messages: 10
Registered: October 2007
Location: India
Junior Member

Use :par1:='''||:par1||''',

hope it will resolve the problem.
Previous Topic: bad bind varibles'CP_DEPOSITE_AMOUNT'
Next Topic: how to display a time range
Goto Forum:

Current Time: Wed Aug 16 10:19:35 CDT 2017

Total time taken to generate the page: 0.08107 seconds