Stored Procedures/Packages - Returning cursor output

[TD_User2036]

Hi,

I have set of oracle stored procedures/packages to port to Teradata and have few queries:

1) What is equivalent of Oracle Packages in Teradata? Also i need group number of procedures into packages, can i do this in Teradata?

2) Can we return resultset (cursor) as output through stored procedures?

Thanks

[CarlosAL]

Hi.

1. There are no PACKAGES in Teradata. SP's are 'standalone'. You could 'group' a set of SP's using a Database (schema) but I wouldn't recomend this way.

2. Take a look at Dynamic Resultsets.

HTH.

Cheers.

Carlos.