Procedures under Catalog & Content

[former_member216748]

Hi,

We can create custom Procedures under Catalog -> Schema's and under Content -> Packages.

Why do we have 2 options, does it have any difference.

Regards

Hari

[former_member226419 · Accepted solution]

Hi,

Catalog procedures are transportable  while schema( content) procedures you cannot transport.

BR

Sumeet

[thomas_jung · Accepted solution]

sumeet durgia wrote:

Hi,

Catalog procedures are transportable  while schema( content) procedures you cannot transport.

BR
Sumeet

You have that backwards.  Content (design time) procedures are created in a package and therefore can be transported via Delivery Unit. Catalog procedures (created directly via SQL) can not be transported via Delivery Unit. Content (design time) procedures also have the advantage of being version managed by the HANA Repository.

[former_member226419 · Accepted solution]

Hi Thomas,

Ya my mistake..   ..I have reversed the order

I mean to say procedures created with package are transportable ( Content one ) and catalog (SQL one ) are not transportable..

BR

Sumeet

[former_member216748 · Accepted solution]

Thanks Thomas, Sumeet.

[Former Member · Accepted solution]

This message was moderated.