> I want to log the use of SP's in the database, is there a
> CURRENT_PROCEDURE_NAME variable so I could use a common piece
> of code in each one.

No, there isn't.

The best thing you can offer is passing the name as a parameter,
eg:

create proceudre myprocedure ( ... )

begin
log_usuage('myprocedure');
...

end;

With regards,

Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
Server
Upscene Productions
http://www.upscene.com