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.
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.