Oracle Built−in Packages- P88: Ah, for the good old days of Version of PL /SQL! Life was so simple then. No stored procedures or functions and certainly no packages. You had your set of built−in functions, like SUBSTR and TO_DATE. You had the IF statement and various kinds of loops. With these tools at hand, you built your batch−processing scripts for execution in SQL*Plus, and you coded your triggers in SQL*Forms , and you went home at night content with a good day's work done. | Appendix A What s on the Companion Disk SET LONG 200 COL chapter_descr FOR A15 COL chapter_text FOR A40 WORD_WRAPPED @compare_text Chapter 1 This is the output of the script CHAPTER DESCR CHAPTER TEXT Chapter 1 It was a dark and stormy night. Suddenly a scream rang out. An EXCEPTION had not been handled. The sun shone brightly the following morning. All traces of the storm had disappeared. Rollback complete. CHAPTER DESCR CHAPTER TEXT Chapter 1 It was a dark and stormy night. Suddenly a scream rang out. An EXCEPTION had not been handled. The procedure The COPY procedure copies all or part of the contents of a source internal LOB to a destination internal LOB. An offset location in each LOB can be specified. The headers for this program corresponding to each LOB type are the following PROCEDURE dest_lob IN OUT BLOB src_lob IN BLOB amount IN INTEGER dest_offset IN INTEGER 1 src_offset IN INTEGER 1 PROCEDURE dest_lob IN OUT CLOB CHARACTER SET ANY_CS src_lob IN CLOB CHARACTER SET dest_lob CHARSET amount IN INTEGER dest_offset IN INTEGER 1 src_offset IN INTEGER 1 The overloaded specification allows COPY to be used with BLOBs CLOBs and NCLOBs. The term ANY_CS in the specification allows either CLOB or NCLOB locators as input. COPY cannot be used with BFILEs because access to BFILEs is read-only. Parameters are summarized in the following table. Parameter Description dest_lob Locator for the destination LOB src_lob Locator for the source LOB amount Number of bytes BLOB or characters CLOB NCLOB to copy dest_offset Location of the byte BLOB or character CLOB NCLOB in the destination LOB at which the copy operation begins the default value is 1 src_offset Location of the byte BLOB or character CLOB NCLOB in the source LOB at which the copy operation begins the default value is 1 Updating BLOBs CLOBs and NCLOBs 426 Appendix A What s on the Companion Disk Exceptions The COPY procedure may raise one of the .
