Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> SQL execution problem (PL/SQL + HTP)
Hi,
I try to execute procedure like this:
procedure verify_user (
i_username IN VARCHAR2,
i_password IN VARCHAR2
)
IS
m_count number;
BEGIN
m_count := 0; i_username := 'admin'; i_password := '123';
select count(*) into m_count from t_users where name = i_username and pass = i_password;
if m_count = 1
THEN htp.print('OK !'); ELSE htp.print('NO RECORDS'); END IF;
QUESTION: This procedure should set m_count to 1 and then print OK in web browser (there is 1 record fulfill a condition - I'M SURE OF THAT !!!). Why it isn't work properly ??? Received on Wed May 19 2004 - 09:27:12 CDT
![]() |
![]() |