3 Replies Latest reply on Jan 8, 2007 2:49 PM by 555038

    Report sort problem (ORA-00911: invalid character)

    512663
      Hello,

      I'm having difficulties to enable the sort option for my column headings. When I create the report and later enable sort then I get the next error:

      failed to parse SQL query:
      ORA-00911: invalid character


      Although my problem is already posted in this forum (Sort causing ORA-00911 I can't find a solution for it without recreating my report region.

      The query:
      Select statement_id,
      statement_nr,
      pkg_invoices.f_format_getal(amount) amount,
      bank_account_nr || ' - ' || bank_name bank,
      amount search_amount,
      statement_dt
      from statements st,
      bank_accounts ba
      where ba.bank_account_id = st.bank_account_id;

      Can anyone help me pls?

      Thanks in advance

      Regards,
      OLI