> Don't know if it is relevant, but you use EXECUTE PROCEDURE when the

procedure itself is a selectable procedure (due to SUSPEND). I suggest that
you either change your call to SELECT R_ID FROM
LOG_WRITE_PRC(:V_USER_ID,:A_IPADDRESS,'User ' ||

> :A_LOGIN_ID || ' successfully logged in.', 'User ' || :A_LOGIN_ID || '

successfully logged in.'); rather than EXECUTE PROCEDURE or replace SUSPEND
with EXIT.

>

Indeed, there's no place for the output parameter to go in the
EXECUTE PROCEDURE call.

!!

So, "parameter mismatch" is correct.

Martijn Tonies
Database Workbench - tool for InterBase, Firebird, MySQL, NexusDB, Sybase
SQL Anywhere, Oracle & MS SQL Server
Upscene Productions
http://www.upscene.com
My thoughts:
http://blog.upscene.com/martijn/
Database development questions? Check the forum!
http://www.databasedevelopmentforum.com