OraFAQ Forum: SQL & PL/SQL » Store a text file into CLOB column

Home » SQL & PL/SQL » SQL & PL/SQL » Store a text file into CLOB column

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

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

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Dec 03 13:59:56 CST 2024