Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: TO_DATE does not work inside PLSQL cursor???
I don't know -
from_date, to_date seem a reasonably pair of names.
If you look at v$sort_usage, you will find that some employees of Oracle Corp have managed to name (and q.a.) a column called USER !
-- Jonathan Lewis Yet another Oracle-related web site: http://www.jlcomp.demon.co.uk Practical Oracle 8i: Building Efficient Databases Publishers: Addison-Wesley Book bound date: 8th Dec 2000 See a first review at: http://www.ixora.com.au/resources/index.htm#practical_8i More reviews at: http://www.jlcomp.demon.co.uk/book_rev.html Nuno Souto wrote in message <3a35ef20.4856709_at_news-server>...Received on Wed Dec 13 2000 - 01:32:59 CST
>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
>