using clob

[sinner]

hi.
i want the code or reference for insert command using the CLOB datatype.

[debasisdas]

Please find a related article here .

[sinner]

Please find a related article here .

thanks for the reference

[subashsavji]

hi.
i want the code or reference for insert command using the CLOB datatype.

[code=oracle]

create table demo
( id int primary key,
theClob clob
)
/

create or replace directory my_files as 'C:\';
/

CREATE OR REPLACE procedure load_a_file( p_id in number,
p_filename in varchar2 )
as
l_clob clob;
l_bfile bfile;
begin
insert into demo values ( p_id, empty_clob() )
returning theClob into l_clob;
l_bfile := bfilename( 'MY_FILES', p_filename );
dbms_lob.fileop en( l_bfile );
dbms_lob.loadfr omfile( l_clob, l_bfile,
dbms_lob.getlen gth( l_bfile ) );
dbms_lob.filecl ose( l_bfile );
end;
/

EXECUTE load_a_file(2,' YY.TXT');

[/code]

[sinner]

[code=oracle]

create table demo
( id int primary key,
theClob clob
)
/

create or replace directory my_files as 'C:\';
/

CREATE OR REPLACE procedure load_a_file( p_id in number,
p_filename in varchar2 )
as
l_clob clob;
l_bfile bfile;
begin
insert into demo values ( p_id, empty_clob() )
returning theClob into l_clob;
l_bfile := bfilename( 'MY_FILES', p_filename );
dbms_lob.fileop en( l_bfile );
dbms_lob.loadfr omfile( l_clob, l_bfile,
dbms_lob.getlen gth( l_bfile ) );
dbms_lob.filecl ose( l_bfile );
end;
/

EXECUTE load_a_file(2,' YY.TXT');

[/code]

thanks for the code
regards