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