Updating clob in pl sql
second, you issued: create directory my_dir as 'd:\sree'; that created a directory MY_DIR. and i modified the procedure as follows: create or replace procedure load_file is l_blob b LOB; l_bfile BFILE:=BFILENAME('my_dir','test.doc'); begin insert into res_det values('hjhj','hjhj', EMPTY_BLOB()) returning resume into l_Blob; dbms_lob.fileopen(l_bfile); dbms_lob.loadfromfile(l_Blob,l_bfile,dbms_lob.getlength(l_bfile)); dbms_lob.fileclose(l_bfile); end; now it is giving me a new error msg SQL exec load_file BEGIN load_file; END; * ERROR at line 1: ORA-22288: file or LOB operation FILEOPEN failed LFI-00108: Open expect the file [test][doc] to exist. June 23, 2004 - am UTC LFI-00108: Open expect the file [test][doc] to exist. file was not there on the server or file was not readable by the server.
in case of text files, image files, pictures, sound files, documents etc. can we use the local files or we have to use the server files?? LOAD_FILE", line 7 ORA-06512: at line 1 plz let me know wat mistake i'm doing everytime tom..i need it a bit urgent.
elwarren is obviously wise in the ways of Perl and Oracle ;-) I could be wrong, but I think you're talking about the oracle "long" datatype.
You can manipulate "long" columns by using placeholders and bind values. Seriously, you're going to need to be a little more comprehensible. And, if I understand you correctly (which there is a good chance I might not), you're asking us to do work for you.
these pages and images are totally cachable by the browser, I need do nothing more nor nothing less. and what did it have to do with inserting CLOB data?
hi tom, still i'm not getting it tom.......i'll expalin u from the starting wat i did..
page is being created on-the-fly as Tom's engine actually currently does, and all images, texts etc. June 24, 2004 - am UTC well, just the text is stored in relational tables. I've 'heard' about caching, http headers and so on.
Show us your attempt, and the information you've already found (or not found), and ask a specific question.
During a recent migration project for one of our customers, I needed to export certain XML rows from a Novell Sentinel 6.1 Oracle 10G R2 Hotfix 4 Database.
In particular, I found that it was not possible to export Filter Configuration in Novell Sentinel 6.1 and I needed the 250 Filters in the new Database and new Sentinel Server.
Not sure if you meant pl/sql or if you meant perl/sql, so here goes.
When using Perl and the DBD:: Oracle module you are able to select LOBs, CLOBs, and BLOBs as a normal field. You will need to tell DBD that you are inserting a LOB, similar to this: While this seems trivial, if you ever put something like a frozen data structure (via the Freeze Thaw module) in a CLOB, you'll end up getting errors all over the place when you later try to thaw it if the frozen structure happens to have whitespace at the end.
COLUMN newline_tag newline; COLUMN date_submit newline; COLUMN mmdd_date_submit newline; COLUMN narrative_desc format A1000 justify left; SELECT ' and the text data, as this output will serve as a template to XML processing.