This shows you the differences between two versions of the page.
kurs:clob2 [2014/09/10 21:22] |
kurs:clob2 [2014/09/10 21:22] (current) |
||
---|---|---|---|
Line 1: | Line 1: | ||
+ | ====== CLOB Prozedur ====== | ||
+ | <file> | ||
+ | PROCEDURE P_CLOB | ||
+ | IS | ||
+ | v_clob clob; | ||
+ | BEGIN | ||
+ | select text into v_clob | ||
+ | from XL_TEst | ||
+ | where ind = 243; | ||
+ | dbms_output.put_line(v_clob); | ||
+ | END; | ||
+ | </file> | ||
+ | **Ergebnis:**\\ | ||
+ | Ein wirklich langer Text, den ich da schreib. | ||