Results 1 to 3 of 3
  1. #1
    Join Date
    Mar 2004
    Location
    japan
    Posts
    35

    Red face Unanswered: run report error (report6i builder)

    hi to all,
    i face the problem when i going to run the report
    the select statement is like below:

    select /*+ORDERED*/ rx_plkno||rx_reno fileno, eq_reno, eq_dt, rx_typ, jt_des, rx_nm,rx_sal,rx_exrem, rx_trem, rx_rem, em_nm,na_desc
    from csy_wempr, rqa_rreqexp, rqa_reqq, csz_typ, csz_nats, csz_expr
    where eq_sub = 'J'
    and rx_sts IN ('P','T','R')
    and eq_dt >= sysdate
    and eq_dt <= sysdate
    and rx_plkno = eq_plkno(+)
    and rx_reno = eq_req(+)
    and eq_reg = em_reg(+)
    and rx_typ = jt_typ(+)
    and rx_natt = na_natt(+)
    and rx_skil = sk_skil(+)
    order by em_nm


    **in order to run this report i connect to certain database already.**

    when going to run this report the error come up with :-

    ORA-24323 :value not allowed
    ==>select /*+ORDERED*/ rx_plkno||rx_reno fileno, eq_reno, eq_dt, rx_typ, jt_des, rx_nm,rx_sal,rx_exrem, rx_trem, rx_rem, em_nm,na_desc



    but when i run this select statement in sql*plus , there are not error come up and can give the result.


    hopefully i can get the help from you all as soon as possible.
    thanks.

    best regard,
    yokaieki

  2. #2
    Join Date
    Mar 2004
    Location
    japan
    Posts
    35
    Pls. reply me as soon as possible .
    Thanks.

  3. #3
    Join Date
    Jan 2004
    Posts
    492
    I'm guessing the hint ordered you are using is not supported by the Report Builder - try taking it out and running it without it
    Oracle OCPI (Certified Practicing Idiot)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •