Home » SQL & PL/SQL » SQL & PL/SQL » Store a text file into CLOB column
Store a text file into CLOB column [message #189438] Thu, 24 August 2006 10:27
Messages: 189
Registered: May 2006
Location: NJ,USA
Senior Member

I haven’t worked on clob datatype till now. But yes I got a chance to work on it right now...
Thought will get help from u guys....Also simultaneously i am searching in net on how to do this.

Here is the scenario..
I need to write a stored procedure which will get two input parameter
1) Filename and
2) Actual file
This will be passed to SP from java layer

Now i need to store this file into a table of below structure

( file_name varchar2(50),
file_content CLOB)

I know that if the content is XML file then i can store it as XMLTYPE. Searched the same on board.

But here the file is in text format and i need to store the entire file as such into the column.

You help is highly appreciated.

Previous Topic: Finding Error Line Numbers in 9i
Next Topic: ORA-03113 when using descending index
Goto Forum:

Current Time: Sun Aug 20 06:56:07 CDT 2017

Total time taken to generate the page: 0.09441 seconds