By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
457,865 Members | 1,365 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 457,865 IT Pros & Developers. It's quick & easy.

How do I Execute Oracle Stored Procedures using SQLDataSource?

P: n/a
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

Sep 13 '06 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.