retrieve « stored procedure « Java Database Q&A

1. retrieve a recordset from a stored procedure?

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

3. How to retrieve dynamic columns from stored procedure

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, ...