Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: order by problem with stored procedure

Re: order by problem with stored procedure

From: Alen Cappelletti <cocker_at_libero.it>
Date: 31 May 2006 06:46:14 -0700
Message-ID: <1149083174.010287.149870@g10g2000cwb.googlegroups.com>

> Which user/schema is invoking this code?
An user with EXECUTE PROCEDURE PERMISSION.

I've simplify but alvays same error.
1) Can be return client cursor?

		var_Query := 'SELECT '||
						'u.*, '||
						'14 TotRs '||
					 'FROM UTENTI u '||
					 'WHERE u.STATO = 1 '||
					 'ORDER BY '||:strOrdinamento;
		--Rs principale
		OPEN OBJ_CUR_Utenti FOR var_Query USING strOrdinamento;
Received on Wed May 31 2006 - 08:46:14 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US