B
Brew
Hello,
I'm writing an ASP.NET 2005 (VB) Website with an Oracle 9i backend
I have an oracle package with stored procedures and functions I need to
use from the
VB Code, I'm trying to use the SQLDataSource to call a stored procedure
passing parameters and then displaying the results on a GridView
control my trouble is with the parameters and displaying results into
the GridView.
Also a related issue is that if the procedure is inside an oracle
package I cannot reference it from the SQLDataSource Wizard (it's not
listed)
here's my sample oracle stored procedure:
***
CREATE OR REPLACE PROCEDURE USP_PAYROLL_TEST (p_recordset1 OUT
SYS_REFCURSOR,
p_TaskNumber IN STRING) AS
BEGIN
OPEN p_recordset1 FOR
SELECT Task_Number
FROM timecard_tmp
WHERE Task_Number = p_TaskNumber;
END USP_PAYROLL_TEST;
/
***
Any help or step by steps would be appreciated!!!!
Thanks!
Brew
I'm writing an ASP.NET 2005 (VB) Website with an Oracle 9i backend
I have an oracle package with stored procedures and functions I need to
use from the
VB Code, I'm trying to use the SQLDataSource to call a stored procedure
passing parameters and then displaying the results on a GridView
control my trouble is with the parameters and displaying results into
the GridView.
Also a related issue is that if the procedure is inside an oracle
package I cannot reference it from the SQLDataSource Wizard (it's not
listed)
here's my sample oracle stored procedure:
***
CREATE OR REPLACE PROCEDURE USP_PAYROLL_TEST (p_recordset1 OUT
SYS_REFCURSOR,
p_TaskNumber IN STRING) AS
BEGIN
OPEN p_recordset1 FOR
SELECT Task_Number
FROM timecard_tmp
WHERE Task_Number = p_TaskNumber;
END USP_PAYROLL_TEST;
/
***
Any help or step by steps would be appreciated!!!!
Thanks!
Brew