Hi,

I would like to execute a SELECT * from table1 order by <XYZ>
and get the results into IN OUT cursor.

I want to pass XYZ as input parameter to stored procedure.
It is treating it as string.

For example: if XYZ value is field1, it is executing the SQL statement
as
SELECT * from table1 order by 'field1'
instead of
SELECT * from table1 order by field1

Please help.

Amritha wrote:
I suppose you could use a ref_cursor, but what kind of design requires such construction?

On Aug 16, 11:51*am, Amritha <amritha.da... (AT) gmail (DOT) com> wrote:
http://www.freelists.org/post/oracle...-in-order-by,2

Or use dynamic sql with a bind variable for the order by.
http://www.oracle-base.com/articles/...dVariables.php

jg
--
@home.com is bogus. “The Accidents of Style: Good Advice on How Not
to Write Badly,” is just out from St. Martin’s Griffin. It covers 350
errors that mar the writing of amateurs and professionals. But what
about editors? Author Charles Elster is mortified by a recurring
accident appearing in “The Accidents of Style.” Twelve times his
middle name, Harrington, is misspelled Huntington.

On Aug 16, 3:07*pm, "Gerard H. Pille" <g... (AT) skynet (DOT) be> wrote:
If there are a limited number of desired order by clauses then this
can be done using a weakly typed Reference Cursor. Based on the input
just assign the correct SQL statement to being the Reference Cursor
value.

Depending on the problem trying to be solved another approach might be
to define a view that performs the base SQL statement and just specify
the desired order by on the query against the join.

Another alternate might be the use of a pipelined function.

Only as a last resort would I use string concatenation and execute
immediate to solve the problem using dynamic SQL.

HTH -- Mark D Powell --