Updating clob in pl sql Online lern sex with cam
Once you create an Oracle Lob instance corresponding temporary LOB appears on the server, and any data you insert into the object is sent immediately to server.
An example of using temporary LOBs you will see later in the article. Write() methods to transfer data to and from server.
Is everything OK with your extracting procedure from the DB?
How do you extract back from the column to the file? with some files that can open on your computer for sure...
Regards, R 22275, 00000, "invalid LOB locator specified" // *Cause: There are several causes: (1) the LOB locator was never // initialized; (2) the locator is for a BFILE and the routine // expects a BLOB/CLOB/NCLOB locator; (3) the locator is for a // BLOB/CLOB/NCLOB and the routine expects a BFILE locator; // (4) trying to update the LOB in a trigger body -- LOBs in // trigger bodies are read only; (5) the locator is for a // BFILE/BLOB and the routine expects a CLOB/NCLOB locator; // (6) the locator is for a CLOB/NCLOB and the routine expects // a BFILE/BLOB locator; // *Action: For (1), initialize the LOB locator by selecting into the locator // variable or by setting the LOB locator to empty.
For (2),(3), // (5) and (6)pass the correct type of locator into the routine.
For BLOB and CLOB data types only LOB locators (pointers to data) are stored in table columns; actual BLOB and CLOB data is stored in separate tablespace. Don't forget to grant read permissions on the folder to all the users that will use it.