Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: SQL execution problem (PL/SQL + HTP)
Damian wrote:
> 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 ???
>
EXACTLY how is this procedure being invoked?
By who from where using what interface?
How does this code know in which browser window to display the text?
Received on Wed May 19 2004 - 19:18:32 CDT
![]() |
![]() |