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

In <9mj0p6015dc_at_drn.newsguy.com> Thomas Kyte <tkyte_at_us.oracle.com> writes:

>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.

So, am I correct in assuming that I can't do "order by" on a long in 7.3.4, at all? Or is thee an alternate aproach? Received on Wed Aug 29 2001 - 14:49:03 CDT