External Stored procedures usage
I have created a stored procedure using shell script and registered the stored procedure. I can invoke the stored proc but it doesn’t serve my purpose. I am using a global temp table inside the stored proc but stored proc doesn't have access to the data that is in global temp table.
Example query -
- Open a session in SQLWorkBench and execute the following query. It inserts one row into GlobalTempTable1
Insert Into GlobalTempTable1 (CompanyId, StartDate, EndDate, DataVendorID, SortOrder, ContributorID)
Values (23567, '6/20/2016', '6/21/2016', 10, 1, 256)
- Execute the following stored proc in the same session opened in step 1.
But Test_proc() is not able to access the data inserted in step 1
Any ideas or working examples on how to use temp tables in Vertica external stored procedure?
Thanks in advance!