Click here to Skip to main content
13,358,244 members (56,868 online)
Click here to Skip to main content
Add your own
alternative version


50 bookmarked
Posted 11 Aug 2004

Oracle Stored Procedure Wrapper

, 11 Aug 2004
Rate this:
Please Sign up or sign in to vote.
This small VB.NET application allows you to quickly generate VB.NET wrapper code for your Oracle stored procedures.

Sample Image - OracleSPWrapper.jpg


This small VB.NET application allows you to quickly generate VB.NET wrapper code for your Oracle stored procedures. This code can then be copy/pasted into your VB.NET application.


Visual Studio has similar tools built in for SQL Server, but their Oracle equivalents are lacking. That's where this tool comes in handy.

Using the Tool

This VB.NET application comes ready to run. All you need is the .NET Framework 1.1 installed and the appropriate Oracle SQL*Net drivers because the application uses the System.Data.OracleClient for database access.

Upon start up, you need to log in to your Oracle database by clicking on the "Login" button and entering your username, password, and database. If the login is successful, the application will populate the list box with all of your stored procedures, whether they're stand-alone or part of a package.

You highlight a stored procedure and click "Go". If you want to name your VB Sub different than the name of the stored procedure, edit the text in the "Sub Name" field.

When you click "Go", the application will query the database for the parameter list of the stored procedure and build a VB.NET Sub in the text box.

To use the Sub, copy and paste the generated text into your application.

Points of Interest

The is a fairly quick-and-dirty application that I needed for a project. As such, it's not extremely robust or fault-tolerant. If there is enough interest here, I can further refine it.

The application works for stored PROCEDURES, but not stored FUNCTIONS, because with functions, a return value is expected. I didn't add support for FUNCTIONS because I didn't need it at the time; all of my procedures use OUT or IN/OUT parameters for passing data back to the application.

I've tested this application on Oracle8i and Oracle9i. Earlier versions may or may not work.


This article has no explicit license attached to it but may contain usage terms in the article text or the download files themselves. If in doubt please contact the author via the discussion board below.

A list of licenses authors might use can be found here


About the Author

Barry Etter
Web Developer
United States United States
No Biography provided

You may also be interested in...

Comments and Discussions

QuestionThank you, just what I needed! 5 stars Pin
woutercx2-Aug-12 0:08
memberwoutercx2-Aug-12 0:08 
Questioncreate username & password coding for Pin
PunithaSabareeswari1-Jun-12 19:37
memberPunithaSabareeswari1-Jun-12 19:37 
QuestionWhat is 'UNIFI' from Pin
wk6pack21-Oct-09 12:38
memberwk6pack21-Oct-09 12:38 
GeneralReturnValue Type is missing Pin
ImranSyed14-Apr-09 23:50
memberImranSyed14-Apr-09 23:50 
Generalplease help i want oracle store procedures using in examples Pin
dilipmca046-Oct-08 21:25
memberdilipmca046-Oct-08 21:25 
Generalnice but Pin
Dan112321-Sep-07 8:30
memberDan112321-Sep-07 8:30 
QuestionWhat about Packages? Pin
mcheschm19-Oct-06 8:14
membermcheschm19-Oct-06 8:14 
Generalcool Pin
Alexandros20051012-Oct-06 0:51
memberAlexandros20051012-Oct-06 0:51 
GeneralBoolean Value Parameter to Oracle SP. Pin
baiju.km18-Sep-06 2:46
memberbaiju.km18-Sep-06 2:46 
GeneralJust a message Pin
chris Liang30-Aug-05 10:14
memberchris Liang30-Aug-05 10:14 
GeneralRe: Just a message - a free one! Pin
Thomas Schittli28-Sep-05 4:13
memberThomas Schittli28-Sep-05 4:13 
QuestionREF_CUR? Pin
emunews2-Jun-05 12:15
memberemunews2-Jun-05 12:15 
Unless I'm doing something wrong, it doesn't seem to support reference cursors. It would be nice if it supported C#, but it's not a bad. It just needs some work, that's all.
AnswerRe: REF_CUR? Pin
Al Ortega10-Oct-05 4:39
memberAl Ortega10-Oct-05 4:39 
AnswerRe: REF_CUR? Pin
HenryBStinson27-Dec-06 8:59
memberHenryBStinson27-Dec-06 8:59 
QuestionHow Can I Generating wrapper code for SQL Server Stored Procedure Pin
Fraas16-Dec-04 16:27
memberFraas16-Dec-04 16:27 
AnswerRe: How Can I Generating wrapper code for SQL Server Stored Procedure Pin
chris Liang30-Aug-05 10:10
memberchris Liang30-Aug-05 10:10 
GeneralRe: How Can I Generating wrapper code for SQL Server Stored Procedure - a free one! Pin
Thomas Schittli28-Sep-05 4:07
memberThomas Schittli28-Sep-05 4:07 
GeneralNot working for output params Pin
exactscience7-Sep-04 10:08
memberexactscience7-Sep-04 10:08 
GeneralNice demo, but... Pin
M@roberts30-Aug-04 7:14
memberM@roberts30-Aug-04 7:14 
GeneralApplication doesn't work Pin
MrNorth17-Aug-04 22:16
memberMrNorth17-Aug-04 22:16 
GeneralRe: Application doesn't work Pin
Sivakumar, Dubai23-Aug-04 1:41
memberSivakumar, Dubai23-Aug-04 1:41 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.

Permalink | Advertise | Privacy | Terms of Use | Mobile
Web02 | 2.8.180111.1 | Last Updated 12 Aug 2004
Article Copyright 2004 by Barry Etter
Everything else Copyright © CodeProject, 1999-2018
Layout: fixed | fluid