Oracle RefCursor concept in Teradata stored procedure

Database

Oracle RefCursor concept in Teradata stored procedure

Hi,
Can we create stored procedures with RefCursors like in Oracle?

My requirement is to fetch a record set from a table and need to display that as an output of the procedure.

Ex: select * from Employee where dept_num = 100;

Please let me know how to do this in teradata.

Thanks in Advance.

Cheers,
Kumar.
1 REPLY
rgs
Enthusiast

Re: Oracle RefCursor concept in Teradata stored procedure

In TD 12 you can define DYNAMIC RESULT sets. See the following thread on the subject in this same topic.

http://www.teradata.com/teradataforum/Topic13703-9-1.aspx