This shows you the differences between two versions of the page.
— |
kurs:clob3 [2014/09/10 21:22] (current) |
||
---|---|---|---|
Line 1: | Line 1: | ||
+ | <file> | ||
+ | PROCEDURE P_CLOB | ||
+ | ( v_in_clob IN clob) | ||
+ | IS | ||
+ | v_clob clob; | ||
+ | BEGIN | ||
+ | select text into v_clob | ||
+ | from XL_Test | ||
+ | where ind = 243 for update; | ||
+ | dbms_LOB.append(v_clob,v_in_clob); | ||
+ | dbms_output.put_line(v_clob); | ||
+ | END; | ||
+ | SQL Navigator macht bei der Ausführung der Prozedur einen Fehler,\\ | ||
+ | den ich umgehen kann, wenn ich folgendes mache: | ||
+ | PROCEDURE P_CLOB | ||
+ | ( v_in_clob IN varchar2) | ||
+ | IS | ||
+ | v_clob clob; | ||
+ | BEGIN | ||
+ | select text into v_clob | ||
+ | from XL_Test | ||
+ | where ind = 243 for update; | ||
+ | dbms_LOB.append(v_clob,v_in_clob); | ||
+ | dbms_output.put_line(v_clob); | ||
+ | END; | ||
+ | </file> |