Archives of the TeradataForum
Message Posted: Mon, 17 Dec 2007 @ 18:43:24 GMT
| Subj: | | Re: Oracle Stored Procs and Macros |
| |
| From: | | Rob Paller |
Until you migrate to Teradata release 12 you will need to modify the stored procedure to load a table. Then you after the stored procedure
completes execution you can return the contents of the table.You can take advantages of Global Temporary tables to virtually eliminate the perm
footprint required by having to work with tables. Global Temp tables will rely on the users temp space and can have single column statistics
collected on them.
In Teradata 12 stored procedures should be permitted to return resultsets.
| 
