Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: order by problem with stored procedure
This is my last code...I compile without error...but when run on my asp
page got this error:
ORA-01006: bind variable does not exist ORA-06512: at "MVS.PKG_UTENTI",
line 35 ORA-06512: at line 1
PROCEDURE Utenti( strCookieMD5 IN varchar2, intDaRs IN number, intArs IN number, strOrdinamento IN varchar2, OBJ_CUR_Utenti OUT CUR_Utenti ) AS var_TotaleRs number; var_Query varchar2(2000); BEGIN --Tot record SELECT NVL(Count(*),0) INTO var_TotaleRs FROM UTENTI WHERE (STATO = 1); 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 var_TotaleRs, strOrdinamento, intDaRs, intArs; END Utenti;
![]() |
![]() |