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:

You're sure you did not forget a newsgroup?

On Aug 16, 9:08*pm, "Gerard H. Pille" <g... (AT) skynet (DOT) be> wrote:

Yup:

comp.databases.oracle.annoying

Cheers.

Carlos.

Hi,
look at "execute immediate"
Build your statement into a varchar variable and then execute it
hth
Kay