Make your own free website on Tripod.com
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/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.

  • Select count(*) from site
  • Select * from site
  • Select * from site where location like '%ON'
  • Try querying another table that may be available in the same schema.
  • 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

    Feedback

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