Tags: 9ias, builder, command, error, hidoes, line, programming, rep-159, reports, run, solve, syntax, tools

REP-159: Syntax error on command line.

On Programmer » Development Tools

1,110 words with 2 Comments; publish: Tue, 12 Feb 2008 13:58:00 GMT; (20046.88, « »)


Does anyone know how to solve this issue?

REP-159: Syntax error on command line.

When run in reports builder it comes out fine.

However on 9iAS,gives me this error.

Why does this happen??



All Comments

Leave a comment...

    • would be helpful if you listed the exact command that you had tried to execute.
      #1; Sat, 23 Feb 2008 12:51:00 GMT
    • I created a report which lists the cities doing business of more than 50% profit.

      In the reports builder I am able to get the proper values and the reports is shown

      But when I integrate the form with report and call the report using the builtin in forms,I find the report coming if I comment this line of code

      set_report_object_property(repid,REPORT_OTHER,'paramform=no flight='||:BLK_MAIN.TXT_FLT_NUM||' fltid='||:BLK_MAIN.TXT_FLT_ID||' fltdt='||:BLK_MAIN.TXT_FLT_DATE||' fmstn='||:BLK_MAIN.TXT_FLT_STATION||' ver='||:BLK_MAIN.CBO_VERSION||' to_stations='||:global.TO_STATIONS||' ALCODE='||:BLK_MAIN.TXT_AIRLINE);

      Otherwise I get a failed job in Ora 9iAS reports server with this error.

      Pls advice

      #2; Sat, 23 Feb 2008 12:52:00 GMT