Parameters in stored procedures

[Ruslan Zasukhin]

On 20/9/07 4:09 PM, "Bart Pietercil" <bart.pietercil at gmail.com> wrote:

> OK, continuing the path....
> 
> create or replace procedure spLogin(in vc_logon varchar,IN
> vc_password varchar,OUT userid long)
> begin
> 
> set userid = select recid from tbl_users where user_logonname =
> vc_logon AND user_password = vc_password;
> IF userid IS NOT null then
> SET @user_id = userid;
> update tbl_users SET last_login_dt = now() WHERE recid = @user_id;
> else
> raiseerror 50001,'Invalid login';
> END if
> 
> end
> 
> generates this error : 15:03:53: Error: Kernel error: 0x71000. line
> 9:14: unexpected token: 50001
> 
> when I use raise NO problem; looking at the wiki it looked as if
> raise and raiseerror where the same ?

AK,

I see TYPO in our SQL grammar!

    raiserror


So please use RAISE for now as workaround


-- 
Best regards,

Ruslan Zasukhin
VP Engineering and New Technology
Paradigma Software, Inc

Valentina - Joining Worlds of Information
http://www.paradigmasoft.com

[I feel the need: the need for speed]