MySQL stored procedure is not returning output value

Has anyone successfully used >>> select last_insert_id()  ???
I am inserting a row into the database, and then I need to return the last Auto-Identity field to the user.  In this case, it's a PK, Auto-Identitify field named 'LogID".

Everything runs fine, but what gets returned is a 0.  Perhaps my SQL is not written properly, not really sure what the problem is.  The Stored Procedure is written below.

Thanks.

-----------------------------------------------------------------------------

DELIMITER $$

DROP PROCEDURE IF EXISTS `reportmetrics`.`spxInsert_ReportTransaction`$$

CREATE PROCEDURE `spxInsert_ReportTransaction`(
IN p_starttime datetime,
IN p_stoptime datetime,
IN p_formid int,
IN p_userid int,
IN p_dsn varchar(20),
IN p_localeid int,
IN p_locationid int,
IN p_selformula varchar(150),
IN p_exportfilename varchar(50),
OUT p_lastinsertid int
)
BEGIN
insert into reportmetrics.transactionlog
      (starttime,
      stoptime,
      formid,
      userid,
      dsn,
      localeid,
      locationid,
      selformula,
      exportfilename
      )
      values
      (p_starttime,
      p_stoptime,
      p_formid,
      p_userid,
      p_dsn,
      p_localeid,
      p_locationid,
      p_selformula,
      p_exportfilename
      );
      select last_insert_id() into @p_something;
      set p_lastinsertid =  @p_something;
    END$$

DELIMITER ;Start Free Trial