Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: order by problem with stored procedure
> 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
![]() |
![]() |