Try this:
1 declare
2 amt binary_integer;
3 offset integer;
4 x number;
5 y clob;
6 begin
7 amt := 5;
8 offset := 1;
9 dbms_lob.createtemporary(y, true);
10 dbms_lob.write(y,amt,offset,'Hello');
11 x := loadmaster(y);
12 dbms_output.put_line(x);
HTH
np70




Reply With Quote