Oracle Stored Procedure Wrapper

• Download source files - 45.7 Kb

Introduction

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.

Background

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.