SQL execution problem (PL/SQL + HTP)

From: Damian <damian_at_kronopol.com.pl>
Date: Wed, 19 May 2004 16:27:12 +0200
Message-ID: <40AB6EC0.203@kronopol.com.pl>

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;

END verify_user;

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