All Forums Database
bjacobs 3 posts Joined 03/16
22 Mar 2016
Java external stored procedure returns ResultSet - how to insert this contents to a (temporary) table

Hallo all,
I have created a Java external procedure that returns a dynamic result set. I can successfully call it and it returns the correct data. Now how can I store this returned data to a new (temporary) table?
Pseudocode to demonstrate what I want: CREATE VOLATILE TABLE temptable AS (SELECT * FROM myStoredProcedure());
Thanks, Björn

tomnolan 594 posts Joined 01/08
22 Mar 2016

It's not possible to use a stored procedure's output dynamic result set as input to another SQL statement.
You will need to change your stored procedure to insert the data into the volatile table.

You must sign in to leave a comment.