Stored Procedures/Packages - Returning cursor output

Database
Visitor

Stored Procedures/Packages - Returning cursor output

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

 

1 REPLY
Junior Supporter

Re: Stored Procedures/Packages - Returning cursor output

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.