Differences

This shows you the differences between two versions of the page.

--- kurs:clob3 [2014/09/10 21:22]
+++ 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>

dokuwiki