*URGENT* Exec Stored Procedure that does not return a cursor

[silenz]

Hi,
i have a stored procedure, SP_1, that take IN two parameter. the stored procedure will manipulate 5tables and then insert selected rows into a table, call TABLE_A.

how do i exec the stored procedure, SP_1 and then create a textual or graphical query source to read data from TABLE_A?

Please help

/

 

[bcaslow]

What database are you executing the SP against: Oracle, SQL Server, ...?

Are you creating a temp table, and wanting to select from the temp table?

If you're not using a temp table, you should be able to use the Stored Procedure Data Source. Otherwise, if you could answer the above questions, I may be able to give more details.


Bill