How to handel preserved words (as a columnname) into a stored procedure??
Hi out there,
Due to some history development (not mine) we had to convert and Interbase database into an Oracle environment. Some tables-columns where named "LABEL". This gave no problem into Interbase and when using a SQL editor this columns can be qeuried in Orcale. But when I want to define a cursor into a stored procedure it returns an error that it will not regognize the right datatype.
Here's the code I use;
ITEM.LABEL||'_'||LPAD(ITEM.ITEM_CODE,4,0) AS TABCOL
WHERE ITEM.MODULE_CODE = xxxx
ORDER BY ITEM.ITEM_CODE;