cant edit clob in a test window

[dnador]

im testing a proc that has an input as clob. when i try to set the variable at the bottom of the test window by clicking on the ...to open the text editor it wont allow me to type anything. the only way i can get it to work is to change the variable to a string in the test window and type the text in the column row area. Is this supposed to work this way?

 

[Marco Kalter]

A normal CLOB cannot have any data before it is passed to the server. For this you must use a Temporary CLOB instead, which requires Oracle8i or later.

------------------
Marco Kalter
Allround Automations

 

[dnador]

Thanks Marco...that works fine...when i choose test from the menu by right clicking on my stored procedure in the tree how come the system puts in a clob instead of temporary clob? shouldn't it know to put the right one in?
Thanks,
Dave

 

[Marco Kalter]

Not really. A Temporary CLOB is not a specific data type (it's still a CLOB), so it cannot be determined from the parameter data type whether or not it should be temporary.

------------------
Marco Kalter
Allround Automations

 

[onnoirs]

I have a procedure which looks something like this:

PROCEDURE GETIDS(
iID_LIST IN CLOB
...

In the procedure I do the following to prepare for some string parsing:

DBMS_LOB.CREATETEMPORARY( t_LOB, TRUE );
DBMS_LOB.COPY( t_LOB, iID_LIST, DBMS_LOB.GETLENGTH( iID_LIST ) );

lEndItems := LENGTH('');
lEnd := DBMS_LOB.INSTR(t_LOB, '', 1, 1) - 3;

I used a Temporary CLOB as stated earlier in this thread and was able to put in text. But unfortunately when I start a debug session I see my iID_LIST does not contain any data.

Any ideas?

Regards,

Onno Ceelen

 

[Marco Kalter]

Can you send me a complete case with program unit and Test Script?

------------------
Marco Kalter
Allround Automations