Back to Papers
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 ;-)
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!