Using Case as a field name in Procedures

[mozgheib]

Hello,

I have an application that references a table with
one of its fields named case.

Now I have an insert statement that reads from the
tables as follows :

insert into tnkinv
select a.id, b.prop,b.value_,b.date_,seq5_tnkinv.nextval,sysdate,user
from "_TANKS" b, tanks a
where a.id = b.id
and a.type = 'PROCESS'
and to_char(b.date_,'dd/mm/yyyy') = to_char(sysdate, 'dd/mm/yyyy')
and b.CASE = 'BASE';


This statement run fine in sqlplus. But the problem
is when I put it in a stored procedure, the procedure
complains that I can't used the case as a field name.
It gives me error number PLS-00103.

Any ideas? I really need it to be part of my stored proc.

Thanks

 

[sem]

You may use any reserved word with double quotes:

and b."CASE" = 'BASE';

BTW, are you sure you have no other errors?

Regards, Dima

http://seminihin.narod.ru

 

[mozgheib]

Thanks a lot. Your help is very much appreciated
it resolved my problem.