why Stored Procedure saved in Permanent Space ? Why not Macro?

UDA
Enthusiast

why Stored Procedure saved in Permanent Space ? Why not Macro?

Hi All,

Can any one tell me why stored procedure saved in Perm space, but Macro is not saved in perm space...

As both are doing the same job why they r not saved in the same place....

Any clue?

Regards,
Ravindra
2 REPLIES
Senior Apprentice

Re: why Stored Procedure saved in Permanent Space ? Why not Macro?

Hi Ravindra,
a macro is just source code like a view, whereas a SP is rewritten by the PE as a kind of embedded SQL program in C and then compiled to a Shared Object (Unix) or DLL (Windows) with a single exported function. That SO/DLL is stored within the database and when you CALL the SP, it's materialized within file system and the exported function is called.

Dieter
Enthusiast

Re: why Stored Procedure saved in Permanent Space ? Why not Macro?

Thanks a lot Mr.Dieter..