Ein Update in Oracle auf den Datentyp LONG lässt sich nicht mit einer einfachen UPDATE Anweisung ausführen.
Hier hilft eine kleine Prozedur weiter.
Update eines LONG-Datentyps mit bis zu 32760 Bytes
|
1 |
<span class="lnum"> 1: </span><span class="kwrd">DECLARE</span> |
|
1 |
<span class="lnum"> 2: </span> v_long LONG; |
|
1 |
<span class="lnum"> 3: </span> <span class="kwrd">CURSOR</span> cur <span class="kwrd">IS</span> <span class="kwrd">SELECT</span> text <span class="kwrd">FROM</span> tab |
|
1 |
<span class="lnum"> 4: </span> <span class="kwrd">WHERE</span> id=2 <span class="kwrd">FOR</span> <span class="kwrd">UPDATE</span>; |
|
1 |
<span class="lnum"> 5: </span><span class="kwrd">BEGIN</span> |
|
1 |
<span class="lnum"> 6: </span> <span class="kwrd">FOR</span> rec <span class="kwrd">IN</span> cur LOOP |
|
1 |
<span class="lnum"> 7: </span> v_long:=rec.text || <span class="str">' Neuer Text'</span>; |
|
1 |
<span class="lnum"> 8: </span> <span class="kwrd">UPDATE</span> tab <span class="kwrd">SET</span> text = v_long <span class="kwrd">WHERE</span> <span class="kwrd">CURRENT</span> <span class="kwrd">OF</span> cur; |
|
1 |
<span class="lnum"> 9: </span> <span class="kwrd">END</span> LOOP; |
|
1 |
<span class="lnum"> 10: </span> <span class="kwrd">COMMIT</span>; |
|
1 |
<span class="lnum"> 11: </span><span class="kwrd">END</span>; |
|
1 |
<span class="lnum"> 12: </span>/ |