Oracle PL/SQL Language Pocket Reference- P25: This pocket guide features quick-reference information to help you use Oracle's PL/SQL language. It includes coverage of PL/SQL features in the newest version of Oracle, Oracle8i. It is a companion to Steven Feuerstein and Bill Pribyl's bestselling Oracle PL/SQL Programming. Updated for Oracle8, that large volume (nearly 1,000 pages) fills a huge gap in the Oracle market, providing developers with a single, comprehensive guide to building applications with PL/SQL and building them the right way. . | PROCEDURE calc_profits company_id_in IN NUMBER profit_type_in IN VARCHAR2 NET If I try to use this procedure in Oracle Forms I must include a value for both parameters even if I use the default calc_profits NET Suppose I now create the following local procedure either in the form itself or in a PL SQL library PROCEDURE of_calc_profits company_id_in IN NUMBER profit_type_in IN VARCHAR2 NET IS BEGIN calc_profits company_id_in profit_type_in END I can now call this procedure using the default value of NET since the Oracle Forms version of the procedure always passes a value to the stored procedure version of_calc_profits In Version of the Oracle Server by the way you will be permitted to use default values in remote procedure calls. This situation with Oracle Server Version 7 reinforces one of my suggestions regarding default parameter values always specify a value for each of the module s parameters even if a value is the same as the default. You will find yourself less vulnerable to problems down the line. Previous Construct Abstract Data Types ADTs Construct Abstract Data Types ADTs Oracle PL SQL Programming 2nd Edition Book Index Next 23. Managing Code in the Database 23. Managing Code in the Database The Oracle Library Navigation Copyright c 2000 O Reilly Associates. All rights reserved. Please purchase PDF Split-Merge on to remove this watermark. Chapter 23 Previous Tips for Parameter Design Next Transaction Integrity and Execute Authority 23. Managing Code in the Database Contents Executing Stored Code Transaction Integrity and Execute Authority Module Validation and Dependency Management Remote Procedure Calls Managing Stored Objects with SQL Plus Using SQL to Examine Stored Objects Encrypting Stored Code You will either embed PL SQL programs in your client-side application as happens in the Oracle Developer 2000 tools or you will store your code in the Oracle database. The term .
