--- In firebird-support@yahoogroups.com, Svein Erling Tysvær
<svein.erling.tysvaer@...> wrote:

>
> 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.

Bingo! You are correct. I should have realized that. I only
recently added a returned value from the LOG_WRITE_PRC procedure, and
consequently it was returning something with no place to put it. I
changed the calling procedure to accommodate the returned value, and
its working perfectly now.

Thank you to all who commented on this. Much appreciated.

Myles