LENGTH not working.

From: Casper Kjaer <casper_at_cs.auc.dk>
Date: Fri, 2 Nov 2001 14:23:12 +0100
Message-ID: <Pine.GSO.4.33.0111021346040.12009-100000@scotty.cs.auc.dk>

I have made a PL/SQL cursor that looks the following way:

CURSOR length IS SELECT LENGTH('hey dude') FROM DUAL;

But when i run the procedure in SQL*PLUS, it says taht: PLS-00222: no function with name 'LENGTH' exists in this scope

What did i do wrong?

-Casper

-- 
**********************************************************


*            Casper Kjaer                                *

*            Dannebrogsgade 8 1.tv                       *

*            9000 Aalborg                                *

*            Tlf: 98169765                               *

*                                                        *

**********************************************************

Received on Fri Nov 02 2001 - 07:23:12 CST