Home
Page
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 ;-) 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! |