0 Replies Latest reply: Aug 21, 2013 7:09 AM by G.Y RSS

    hypen character in Record group

    G.Y

      oracle forms 10, database 10g

      I want space in record group between two columns

      below is my script

       

      rg_city :=CREATE_GROUP_FROM_QUERY(rg_name , 'SELECT TO_CHAR(ITEM_NAME)||'-'||TO_CHAR(MODEL_NO), TO_CHAR(ITEM_CODE)
       FROM UBN.ITEMS order by ITEM_NAME DESC');
      

       

      i am facing the following error ORA_06502

       

      thanks