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/ado6.html. You will be redirected in 5 seconds but it would be better to update your bookmarks ;-)

Conclusion

Try some of the following examples to test the generic querying tool that you've just developed.

You can use the basic development approach described to develop all manner of client server applications that combine an elegant VB front-end with the efficiency of PL/SQL running on the back-end database server

Editors Note. In fact, Alastair missed a trick here ... (not surprising since he'd only just attended his first PL/SQL course!) PL/SQL allows you write overloaded versions of Procedures when they're stored in a Package, so he could have written two versions of AL_PROCEDURE1, both called AL_PROCEDURE1 but with different parameter lists. Oracle would then have checked the parameter data types passed at runtime and called the correct version of the procedure. Although there would still be two different versions of the procedure to maintain, the same call could be made from the client-end code. This means you can develop a front-end which will work for both types of input!

Additional Resources

You may want to return Result Sets from PL/SQL Packaged procedures to other languages. There is a terrific reference on this subject available here.

There may also be some additional material at Learning Tree's TechTips site.

Previous