Home Page

Back to Papers


Introduction and Set-up

PL/SQL Package Header

PL/SQL Package Body

Visual Basic Code I

Visual Basic Code II

Conclusion and Additional Resources

Please note this page has moved to http://oracledoug.com/ado5.html. You will be redirected in 5 seconds but it would be better to update your bookmarks ;-)

Running AL_PROCEDURE2

The VB code for executing AL_PROCEDURE2 is virtually identical, apart from two lines.

Simply comment out the following line (which specifies which procedure to execute - the format is PACKAGENAME.PROCEDURENAME):

Cmd.CommandText = "AL_PACKAGE.AL_PROCEDURE1"

And insert the following line:

Cmd.CommandText = "AL_PACKAGE.AL_PROCEDURE2"

Also, comment out the following create parameter line:

Cmd.Parameters.Append Cmd.CreateParameter("SiteID", adVarChar, adParamInput, 10, TxtQuery.Text)

And insert the following line in its place:

Cmd.Parameters.Append Cmd.CreateParameter(QueryStr, adVarChar, adParamInput, 2000, TxtQuery.Text)

That's all there is to it! Resave the project and hit run. This time, type a valid SQL query (do not append a semi-colon to the end of the statement) into the query text box and click the button. You should see the results of your query in the results text box!

Previous

Next

Technical Papers Utilities and Scripts Book Reviews Links
My Resume Fun & Games Email Home