Holger B
Member²
Hello,
I am facing an issue, which I have thought had already been fixed.
To enter long string data into a test window you have to use Temporry CLOB instead of CLOB as parameter type. So far so good. Editing the Temporary CLOB and pasting in some data does not work. You close the editor and reopen it, the data is gone.
The script will still show the length of the entered data, but the substring of the CLOB is NULL.
Any ideas?
Greetings
Holger
--------------------------------------------
DECLARE
-- Local variables here
i INTEGER;
BEGIN
-- Test statements here
i := dbms_lob.getlength
v_clob);
dbms_output.put_line('Len CLOB # ' || i);
dbms_output.put_line('CLOB # ');
dbms_output.put_line(dbms_lob.substrv_clob, 1, 200));
END;
--------------------------------------------
I am facing an issue, which I have thought had already been fixed.
To enter long string data into a test window you have to use Temporry CLOB instead of CLOB as parameter type. So far so good. Editing the Temporary CLOB and pasting in some data does not work. You close the editor and reopen it, the data is gone.
The script will still show the length of the entered data, but the substring of the CLOB is NULL.
Any ideas?
Greetings
Holger
--------------------------------------------
DECLARE
-- Local variables here
i INTEGER;
BEGIN
-- Test statements here
i := dbms_lob.getlength
v_clob);dbms_output.put_line('Len CLOB # ' || i);
dbms_output.put_line('CLOB # ');
dbms_output.put_line(dbms_lob.substr
v_clob, 1, 200));END;
--------------------------------------------
Last edited:
