1 Reply Latest reply: Dec 27, 2012 5:30 AM by kikolus RSS

    ora-00933 sql not properly ended.

    user2040934
      Dear members,

      I have the following query in Report Builder 10g,

      select a, b, c
      from table1
      where a=12

      &p_whr_fy &p_whr_supp &p_whr_bt &p_whr_mat_spec &p_whr_lc_num &p_whr_cotton &P_WHR_LOC_ID

      union all

      select a, b, c
      from table2
      where a=12

      &p_whr_fy &p_whr_supp &p_whr_bt &p_whr_mat_spec &p_whr_lc_num &p_whr_cotton &P_WHR_LOC_ID

      here I used lexical parameters, and with spaces in lines its ok but when try to edit the query / remove the spaces in lines it gives the error.

      ora-00933 sql not properly ended

      Regards: