> How do i create a temporal table ?

You cannot.

> Is there a way to create that temp table from a stored procedure ?

No.

But - explain what you want to do so we can give a hand.

With regards,

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