Ciao Fabio,

Codebue Fabio - P-Soft ha scritto:

> I'm transalting a stored procedure that we made in MSSQL.
>
> but during conversion I have some problem....
> exactly I can create a GTT into a SP?
>
> some one can give me some idea what I have to change ?

I'd avoid DDL in stored procedures: it's not the best place to do it.
Again "COMMIT" in stored procedures, AFAIR, it's not supported.
As reported by Carlos, EXECUTE STATEMENT can solve, but I'd care about
transation isolation in DDL and in metadata caching: I'd commit and
reconnect to be sure.
GTT are best intended to be created at some point in development and
then to use them with transaction or connection data persistence:
creating and destroyng GTT often seems a bad design implementation.
Reading your SP (I see it's an example), you create a GTT with fixed
name, so why to create it in SP?
Ciao.
Mimmo.