cancel
Showing results for 
Search instead for 
Did you mean: 

How to pass a parameter from BO .

Former Member
0 Kudos

Post Author: Karthick

CA Forum: General

Hi All,I have a query in passing a parameter from BO environment to a stored procedure written in Microsoft SQLSERVER 2000. This procedure will dynamically generate the records and populate in table will will be referred for the reports. The hint of this

requirement is as follows,

Pass a parameter

(from BO) à Stored Procedure

(Sqlserver) à this will populate

the records in a table à this table will be

referred by the business (for reports)

Thanks in Advance,Karthick

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

Post Author: hbobbitt

CA Forum: General

Why do you need to populate a table with the rows? Why not use the parameter passed from BO to create a recordset that is returned by the stored procedure containing the rows you would have otherwise put into the physical table? I am not a SQL Server developer, but I know this is possible using recordsets from .Net, and it is also possible from Oracle and BO has no problem doing that - we do it all the time, and that way you do not need to consume temporary table space. I am assuming you are deleting rows from this table after reporting on them or at some interval? If so, your current approach will not scale well...