Dynamic "Orde by" parameter in Oracle Stored procedure

#1

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.

#2

On Aug 16, 8:53*pm, Amritha <amritha.da... (AT) gmail (DOT) com> wrote:

Quote:

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.

Take a look at 'Dynamic SQL'

Cheers.

Carlos.

#3

On Aug 16, 1:53*pm, Amritha <amritha.da... (AT) gmail (DOT) com> wrote:

Quote:

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.

reference cursor? Just a quick answer to maybe help.

#4

On Aug 16, 1:53*pm, Amritha <amritha.da... (AT) gmail (DOT) com> wrote:

Quote:

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.

reference cursor? Just a quick answer to maybe help.

#5

On Aug 16, 2:53*pm, Amritha <amritha.da... (AT) gmail (DOT) com> wrote:

Quote:

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.

Show us your procedure code. We can't help if we don't know what
you've done.

David Fitzjarrell

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Dynamic "Orde by" parameter in Oracle Stored procedure

comp.databases.oracle.server comp.databases.oracle.server

Dynamic "Orde by" parameter in Oracle Stored procedure - 08-16-2010 , 01:53 PM

Re: Dynamic "Orde by" parameter in Oracle Stored procedure - 08-16-2010 , 02:17 PM

Re: Dynamic "Orde by" parameter in Oracle Stored procedure - 08-16-2010 , 02:38 PM

Re: Dynamic "Orde by" parameter in Oracle Stored procedure - 08-16-2010 , 02:38 PM

Re: Dynamic "Orde by" parameter in Oracle Stored procedure - 08-16-2010 , 04:05 PM