Parameters in stored procedures

[Ivan Smahin]

Hello Bart,

Thursday, September 20, 2007, 4:09:45 PM, you 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 ?

Misprint in the parser : raiserror there.
Will be fixed.





> _______________________________________________
> Valentina mailing list
> Valentina at lists.macserve.net
> http://lists.macserve.net/mailman/listinfo/valentina



-- 
Best regards,
Ivan Smahin 
Senior Software Engineer
Paradigma Software, Inc
Valentina - The Ultra-Fast Database
http://www.valentina-db.com