Store Procedure

Database
Highlighted
Teradata Employee

Store Procedure

Hi

 

Is there any way in teradata by which I can insert the result set of the another Store procedure into a table.

 

Something like below (Syntax is wrong here)

insert INTO VT_invalidFilesTable
(FileName, Description, FileContent)
CALL "LOG".usp_DailySalesReportGetFiles(1, forInvalidFiles);

 

Thanks

Akshat

1 REPLY
Junior Contributor

Re: Store Procedure

If you need to access the result outside of the SP you should use an Insert/Select into a Global Temporary Table instead of returning a Dynamic Result Set.