Stored Procedures in Content vs Catalog

[Former Member]

Hi All,

Please help me in understanding the differences between stored procedures created in Catalog view vs Stored Procedures created in Content view. For one , I know that Table Type parameters are not supported in Content Stored Procedures. Please let me know if there are other differences.

[SergioG_TX]

Hi Divya,

it is recommended to use design time (hdbprocedure) because they can be transported with your DU or your changelist.

dependign on your HANA SP - you could create your table types inline (SP09+) if before SP09 then you have to create the table type on a different file (runtime object)

[former_member186082]

Hi Divya,

Procedures created in content are design time objects (run time object is created in _SYS_BIC schema), can be transported using delivery unit, can be debugged, version management is possible.

Procedures created in catalog are run time objects, cannot be transported using delivery unit, cannot be debugged, version management is not possible.

Regards,

Chandu.

[Former Member]

Hi Chandra,

     Nice collation of differences. But I would like to differ on two of points mentioned.

Procedures created in content are design time objects (run time object is created in _SYS_BIC schema - This depends on the extension of the procedure. A .procedure would be create and executed via _SYS_BIC while a .hdbprocedure would be called as “Schema_name”.”proc_name”

Procedures created in catalog cannot be debugged - Procedures created in catalog can also be debugged.

[former_member222157]

Agree with Sanjog...

[former_member186082]

Thanks Sanjog for correcting