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

In article <9mirdb$5co$1_at_panix3.panix.com>, stanb_at_panix.com says...
>
>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?

This cannot be done dynamically in versions prior to Oracle8i (815 and up).

You need to use native dynamic sql and thats not available until then.

DBMS_SQL won't work in 7.3 -- not "pure" enough.

--
Thomas Kyte (tkyte@us.oracle.com)             http://asktom.oracle.com/ 
Expert one on one Oracle, programming techniques and solutions for Oracle.
http://www.amazon.com/exec/obidos/ASIN/1861004826/  
Opinions are mine and do not necessarily reflect those of Oracle Corp