PL/SQL lets you declare local variables and constants and then use those identifiers in your PL/SQL program. You can declare the variables and constants to be a datatype known to the RDBMS, such as NUMBER or VARCHAR2. However, you can also make use of PL/SQL−specific data structures such. | Appendix A What s on the Companion Disk Appendix A What s on the Companion Disk Table of Contents A. What s on the Companion Disk .2 Installing the .3 A. 2 Using the .5 B. Calling Stored Procedures from PL SQL Version B. 1 Using Stubs to Talk to Server-Side PL .9 B. 2 Restrictions on Calling Stored No Server-Side PL SQL No Direct Stored Package Variable No Direct Remote Procedure B. No Default Parameter .14 C. Built-In C. 1 Using the Built-in .18 C. The REGISTER The REMOVE procedure .18 The REMOVEALL The SET_DEFAULTS The SIGNAL The WAITANY The WAITONE .20 Oracle AQ the Advanced Queueing DBMS_AQ PL SQL 8 Only .20 DBMS_AQADM PL SQL 8 Only .21 .24 The ALTER_COMPILE The ANALYZE_OBJECT .25 DBMS_ The BROKEN The CHANGE The INTERVAL The ISUBMIT The NEXT_DATE The REMOVE The RUN The SUBMIT The USER_EXPORT The WHAT .28 DBMS_LOB PL SQL8 Only .28 The APPEND The COMPARE The COPY i Appendix A What s on the Companion Disk Table of Contents The ERASE The FILECLOSE The FILECLOSEALL The FILEEXISTS The FILEGETNAME procedure .29 The FILEISOPEN The FILEOPEN The GETLENGTH The INSTR The READ The SUBSTR The TRIM The WRITE .33 The
