TO_DATE does not work inside PLSQL cursor???

Hi fellas.

Found out what the problem was.

The table has a column with the name (wait for it!)

TO_DATE NOT NULL DATE !!!!!!

Now, this is not a problem if you use the function TO_DATE in a normal SQL statement.
But if you use it inside a cursor in a PL/SQL block, all hell breaks loose: PL/SQL will think the TO_DATE is your column, not the function. And it plonks you a PLS-00222 for good measure.

This is a problem with PL/SQL.

Of course, no one in his/her right mind would create such a column in an ORACLE table. Except Sybaser's converting to ORACLE. <sigh>.....

Cheers
Nuno Souto
nsouto_at_bigpond.net.au.nospam
http://www.users.bigpond.net.au/the_Den/index.html Received on Tue Dec 12 2000 - 03:36:43 CST