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

In article <9mm9gd$ctq$1_at_panix2.panix.com>, stanb_at_panix.com says...
>
>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?

In 7.3 you need a procedure with a static query. The tablename cannot change.

You will need a procedure per LONG COLUMN in your database.

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