report  builder

Posted on 2006-05-08
Last Modified: 2008-01-09
I am trying to run a report from a form(a form has a run  report button) and when I click on that it calls a report (rep file)
But when I clcik on run report , it gives me an error:
REP-159: Syntax error on command line.

what could be the issue...( i am trying to run the report from the appliaction to which I log on  through a link http:my_application
Question by:Sara_j_11
    LVL 27

    Assisted Solution

    you should show, how you run the report

    >what could be the issue..
    >REP-159: Syntax error on command line.
    guess one/some commandline-parameters are wrong

    Author Comment

    where do i find the problem... if one of the commandline-parameters are wrong?
    LVL 6

    Accepted Solution

    Check if any of your parameters contain a space.  If so, remove spaces and try again.
    LVL 6

    Expert Comment

    If the spaces are your problem, you can surround the parameter value containing spaces with extra single quotes,

    v_cond VARCHAR2(100) := ''''||'WHERE STATUS IS NULL'||'''';

    Author Comment


    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    PRTG Network Monitor: Intuitive Network Monitoring

    Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

    Truncate is a DDL Command where as Delete is a DML Command. Both will delete data from table, but what is the difference between these below statements truncate table <table_name> ?? delete from <table_name> ?? The first command cannot be …
    Checking the Alert Log in AWS RDS Oracle can be a pain through their user interface.  I made a script to download the Alert Log, look for errors, and email me the trace files.  In this article I'll describe what I did and share my script.
    Via a live example, show how to take different types of Oracle backups using RMAN.
    This video shows how to copy an entire tablespace from one database to another database using Transportable Tablespace functionality.

    737 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    22 Experts available now in Live!

    Get 1:1 Help Now