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
navkrish
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

table_load
( 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.


Naveen
Previous Topic: View running SQL
Next Topic: Finding Error Line Numbers in 9i
Goto Forum:
  


Current Time: Fri Dec 09 08:04:05 CST 2016

Total time taken to generate the page: 0.14459 seconds