Execute SQL StoredProcedure with multiple resultsets in Operations Orchestration
I have an SQL Stored Procedure with multiple Result Sets like below,
create procedure dbo.GetSomething
as begin select * from dbo.Person; select * from dbo.Car; end;
Where I need to execute it in HPOO to get both the result sets. Please help me with this.
Thanks in Advance.
Judging by the script you can create the procedure with OOusing the SQL script operation from base content pack. After it has been created just use a standard sql command operation (again from base content pack) to execute the stored procedure and get the desired results.
Hope this helps,
Thanks for your valuable reply. But it was not about Creating the procedure, but to get the results when I have multiple SELECT statements/Result Sets in a Procedure.
Since that is the case run a sql query (base cp : Library/Operations/Databases/JDBC ) which will should give you all the results in an iterattive manner, or try the sql script operation from the same folder.