tailieunhanh - Oracle Built−in Packages- P81

Oracle Built−in Packages- P81: 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 given pattern LOADFROMFILE Loads all or part of external LOB to internal LOB No READ Provides piece-wise read access to a LOB No SUBSTR Provides piece-wise read access to a LOB Yes TRIM Trims the contents of an internal LOB to the length specified by the newlenparameter No WRITE Writes a given number of bytes or characters to an internal LOB at a specified offset No Table Table shows which LOB types you can manipulate with the individual DBMS_LOB programs. For an explanation of these LOB types see the section Section LOB Concepts later in this chapter. Table DBMS_LOB Programs Can Manipulate These LOB Types Program BFILE BLOB CLOB NCLOB APPEND X X X COMPARE X X X X COPY X X X ERASE X X X FILECLOSE X FILECLOSEALL X FILEEXISTS X FILEGETNAME X FILEISOPEN X FILEOPEN X GETLENGTH X X X X INSTR X X X X LOADFROMFILE X X X X READ X X X X SUBSTR X X X X TRIM X X X WRITE X X X 8. Managing Large Objects 391 Appendix A What s on the Companion Disk DBMS_LOB Exceptions Table Table summarizes the exceptions declared by DBMS_LOB. Table DBMS_LOB Exceptions Exception SQLCODE Cause INVALID_ARGVAL -21560 DBMS_LOB expects a valid argument to be passed but the argument was NULL or invalid. Example FILEOPEN is passed an invalid open mode. Example a positional or size argument is outside of the range 1 through 4 gigabytes-1 . ACCESS_ERROR -22925 An attempt to read or write beyond maximum LOB size has occurred. NOEXIST_DIRECTORY -22285 The directory specified does not exist in the data dictionary. NOPRIV_DIRECTORY -22286 The user does not have the required privileges on either the specified directory object or the specified file. INVALID_DIRECTORY -22287 The directory specified is not valid or has been modified by the database administrator since the last access. OPERATION_FAILED -22288 An operation attempted on a file failed. UNOPENED_FILE -22289 An operation was performed on a file that was not open. OPEN_TOOMANY -22290 The