This discussion is archived
0 Replies Latest reply: Aug 21, 2013 5:09 AM by G.Y RSS

hypen character in Record group

G.Y Newbie
Currently Being Moderated

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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points