1. retrieve a recordset from a stored procedure? coderanch.com
1. how to retrieve a recordset from a stored procedure? 2. do i need to use package for 1? or just use procedure is enough? (can u show me an example?) Please give some advice as soon as you can! thanks. [This message has been edited by yukeshean (edited July 26, 2001).]
2. Retrieve Stored Procedure Code coderanch.com
3. How to retrieve dynamic columns from stored procedure coderanch.com
Hi , I was given a procedure which expects one value and retrieves me the list of columns which may vary depending upon the input parameter CREATE PROCEDURE [FLX].[GETANS] @ques VARCHAR(200) AS BEGIN // some code that creates a temp table which has the dynamic cols create table #temp1( SELECT * FROM #temp1 END When I execute this procedure from db2, ...