471,067 Members | 1,544 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,067 software developers and data experts.

How do I Execute Oracle Stored Procedures using SQLDataSource?

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
0 2081

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

1 post views Thread by Chad | last post: by
2 posts views Thread by rcc.gamer | last post: by
1 post views Thread by Evan M. | last post: by
reply views Thread by =?Utf-8?B?X3ByZWZpeA==?= | last post: by
4 posts views Thread by --CELKO-- | last post: by
reply views Thread by leo001 | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.