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

From: Stan Brown <stanb_at_panix.com>
Date: 30 Aug 2001 16:59:57 -0400
Message-ID: <9mm9gd$ctq$1@panix2.panix.com>

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

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

>You cannot DYNAMICALLY generate the query in the procedure -- you would need a
>procedure/long column (and change the substr to be 2000 bytes as the is the max
>varchar2 length in 7.x)

So you are saying I would have to have a procedure with the collumn name hard coded? Thus I would need a procedure for each collumn name I need to use it on?

How about the table name, it can be dynamic, right? Received on Thu Aug 30 2001 - 15:59:57 CDT