Re: How to "order by" on long data type

From: Stan Brown <stanb_at_panix.com>
Date: 29 Aug 2001 09:40:59 -0400
Message-ID: <9mirdb$5co$1@panix3.panix.com>

Unfortunately my version of Oracle (7.3.4)nay be too early to use this function. Here are the errors I am getting:

Warning: Function created with compilation errors.

Errors for FUNCTION GET_LONG:

LINE/COL ERROR

-------- -----------------------------------------------------------------
8/17     PLS-00103: Encountered the symbol "IMMEDIATE" when expecting one
         of the following:
		  := . ( @ % ;
	   The symbol ":= was inserted before "IMMEDIATE" to continue.

11/8     PLS-00103: Encountered the symbol "INTO" when expecting one of
         the following: . ( * @ % & = - + ; < / > in mod not rem an exponent (**)


		 <> or != or ~= >= <= <> and or like between is null is not ||

Any sugestiosn as to a how to fix this, so that I can use it on my version? Received on Wed Aug 29 2001 - 08:40:59 CDT