Oracle8 CLOB with remote webserver question

From: jamesf <uzada_at_my-dejanews.com>
Date: Tue, 09 Mar 1999 22:39:11 GMT
Message-ID: <7c47ue$7ev$1@nnrp1.dejanews.com>

All --

The scenario is that I have a storyserver install on machine A and an oracle database on machine B. The data passed around is components of the web pages, and the biggest headache is the body of the web page. The length of these pages is highly variant, a couple of K up to (so far a max of 31000 chars... although that is the exception more than the rule).3000 chars is the norm. Oracle suggests using the CLOB vs. the LONG because it is more accessible.

The problem is the web-based editing tool which takes in the data from the database (no problem), but placing the modified data back into machine B from machine A seems problematic. I'm wondering if I'm missing something with the whole DBMS_LOB.LOADFROMFILE() as the only way of getting the data into the CLOB in the database.

i.e.

BEGIN
--

• get the pointer to the CLOB
  --
  UPDATE article_table SET ( body=EMPTY_CLOB() ) WHERE id=inId RETURNING body INTO CLOB_current;

--

• initialize the BFILE locator
  --
  CLOB_file := BFILENAME('DIRECTORY', '/export/home/me/filename');

--

• open file
  --
  DBMS_LOB.FILEOPEN(CLOB_file);

--

• LOAD clob into CLOB_current from CLOB_FILE
  --
  DBMS_LOB.LOADFROMFILE(CLOB_current, CLOB_file, DBMS_LOB.GETLENGTH(CLOB__file));

--

• close file
  --
  DBMS_LOB.FILECLOSE(CLOB_file);

END; As I see it, I have to first transport (NFS mount, ftp... ???) the physical file over to machine B and then run the stored procedure to complete the update. Is there a different/better way?

thanks in advance,

++++++++++++++++++++++++++++++++

James Francis, JAFD

-----------== Posted via Deja News, The Discussion Network ==----------
http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Tue Mar 09 1999 - 16:39:11 CST