How do I Execute Oracle Stored Procedures using SQLDataSource?

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Members online

No members online now.

Forum statistics

Threads
473,989
Messages
2,570,207
Members
46,782
Latest member
ThomasGex

Latest Threads

Top