Re: order by problem with stored procedure

From: Alen Cappelletti <cocker_at_libero.it>
Date: 31 May 2006 06:19:55 -0700
Message-ID: <1149081595.141303.43930@u72g2000cwu.googlegroups.com>

Thanks...
always return a BAD bind variable...
you see my error?

Is support for return cursor on client? Like a recodset of a web page.

---

		var_Query := 'SELECT * FROM ( '||


									 'SELECT '||

										'u.*, '||
										:var_TotaleRs||' TotRs, '||
										'rownum SeqNum '||


									 'FROM UTENTI u '||

									 'WHERE u.STATO = 1 '||

									 'ORDER BY '||:strOrdinamento||

								     ' )'||
		  			 'WHERE SeqNum > '||:intDaRs||
					 ' AND SeqNum <= '||:intArs;
		--Rs principale
		OPEN OBJ_CUR_Utenti FOR var_Query USING intDaRs, intArs,

strOrdinamento Received on Wed May 31 2006 - 08:19:55 CDT