I think this is an Oracle bug, but I just want to check out any other ideas.
I am having problems inserting a value of a certain length into a CLOB column.
I am using bind variables and dynamic SQL to do this because of obvious problems using a straight update statement.
When this problem happened, the limit of the field was 4000 characters. But then this limit seemed to drop the more I experimented with the problem.
The problem is as follows:
If I insert a value < limit, then no problem.
If I insert a value > limit, then there is no error but the value of the field is null.
I will put all the sql below. Apologies if it makes it unreadable.
Basically, in the spool below:
temp3.sql gets the value of the clob column.
temp1.sql inserts a value < limit with no problem
temp2.sql inserts a value > limit, no error, but temp3 shows that the value is null.
temp2.sql is ONE character longer than temp1.sql
Oracle version is 8.1.6.0.0
Can anyone else produce this?
Here's the sql that does it:
SQL> get temp3.sql
1* select site_credits_html from co_working.bcs where bcs_id = 3538
SQL> /
SITE_CREDITS_HTML
--------------------------
----------
----------
----------
----------
----------
----
<p>No other text on the market today can match the success of Halliday, Resnick
and Walker's <b><i>Fundamentals of Physics.</i></b> This text continues to outpe
rform the competition year after year, and the new edition will be no exception.
Intended for Calculus-based Physics courses, the Sixth Edition of this extraord
inary text is a major redesign of the best-selling Fifth Edition, which still ma
intains many of the elements that led to its enormous success. Jearl Walker adds
his unique style to this edition with the addition of new problems designed to
capture, and keep, students' attention. Nearly all changes are based on suggesti
ons from instructors and students using the Fifth Edition, from reviewer comment
s, and from research done on the process of learning. The primary goal of this t
ext is to provide students with a solid understanding of fundamental physics con
SITE_CREDITS_HTML
--------------------------
----------
----------
----------
----------
----------
----
cepts, and to help them apply this conceptual understanding to quantitative prob
lem solving.</p><br /><table border="1" width="375" cellpadding="5"><tr><th widt
h="50%">VERSION</th><th>IS
BN</th><th
>CONTENTS<
/th></tr><
tr><td valign="top">Regu
lar Edition</td><td valign="top">0-471-32000-5
</td><td valign="top">Chapters 1?3
8</td></tr><tr><td valign="top">Extended Edition</td><td valign="top">0-471-3323
6-4</td><td valign="top">Chapters 1?45; contains seven additional chapters on qu
antum physics and cosmology.</td></tr><tr><t
d valign="top">Volume 1</td><td vali
gn="top">0-471-33235-6</td
><td valign="top">Chapters 1?21; Mechanics/Thermodynam
ics (Cloth)</td></tr><tr><td valign="top">Volume 2</td><td valign="top">0-471-36
037-6</td><td valign="top">Chapters 22?45; E p M and Modern Physics (Cloth)</td>
</tr><tr><td valign="top">Part 1</td><td valign="top">0-471-33234-8
</td><td vali
SITE_CREDITS_HTML
--------------------------
----------
----------
----------
----------
----------
----
gn="top">Chapters 1?12 (paperback)</td></tr><tr><
td valign="top">Part 2</td><td
valign="top">0-471-36041-4
</td><td valign="top">Chapters 13?21 (paperback)</td><
/tr><tr><td valign="top">Part 3</td><td valign="top">0-471-36040-6
</td><td valig
n="top">Chapters 22?33 (paperback)</td></tr><tr><
td valign="top">Part 4</td><td
valign="top">0-471-36039-2
</td><td valign="top">Chapters 34?38 (paperback)</td><
/tr><tr><td valign="top">Part 5</td><td valign="top">0-471-36038-4
</td><td valig
n="top">Chapters 39?45 (paperback)</td></tr></tab
le><p>No other text on the mark
et today can match the success of Halliday, Resnick and Walker's <b><i>Fundament
als of Physics.</i></b> This text continues to outperform the competition year a
fter year, and the new edition will be no exception. Intended for Calculus-based
Physics courses, the Sixth Edition of this extraordinary text is a major redesi
SITE_CREDITS_HTML
--------------------------
----------
----------
----------
----------
----------
----
gn of the best-selling Fifth Edition, which still maintains many of the elements
that led to its enormous success. Jearl Walker adds his unique style to this ed
ition with the addition of new problems designed to capture, and keep, students'
attention. Nearly all changes are based on suggestions from instructors and stu
dents using the Fifth Edition, from reviewer comments, and from research done on
the process of learning. The primary goal of this text is to provide students w
ith a solid understanding of fundamental physics concepts, and to help them appl
y this conceptual understanding to quantitative problem solving.</p><br /><table
border="1" width="375" cellpadding="5"><tr><th width="50%">VERSION</th><t
h>ISBN
</th><th>CONTENTS</th></tr
><tr><td valign="top">Regular Edition</td><td valign="
top">0-471-32000-5</td><td
valign="top">Chapters 1?38</td></tr><tr><td valign="t
SITE_CREDITS_HTML
--------------------------
----------
----------
----------
----------
----------
----
op">Extended Edition</td><td valign="top">0-471-33236-4
</td><td valign="top">Cha
pters 1?45; contains seven additional chapters on quantum physics and cosmology.
</td></tr><tr><td valign="top">Volume 1</td><td valign="top">0-471-33235-6
</td><
td valign="top">Chapters 1?21; Mechanics/Thermodynamics (Cloth)</td></tr><tr><td
valign="top">Volume 2</td><td valign="top">0-471-36037-6
</td><td valign="top">C
hapters 22?45; E p M and Modern Physics (Cloth)</td></tr><tr><td valign="top1234
SQL>
SQL>
SQL> get temp1.sql
1 DECLARE
2 v_update_cursor INTEGER;
3 v_update_stmt VARCHAR2(500);
4 v_dummy INTEGER;
5 BEGIN
6 v_update_cursor := DBMS_SQL.OPEN_CURSOR;
7 v_update_stmt :=
8 'UPDATE co_working.bcs '||
9 'SET site_credits_html = :site_credits_html '||
10 'WHERE bcs_id = 3538';
11 DBMS_SQL.PARSE(v_update_cu
rsor, v_update_stmt, DBMS_SQL.NATIVE);
12 DBMS_SQL.BIND_VARIABLE(v_u
pdate_curs
or, ':site_credits_html', '<p>No other text on the market today can match the success of Halliday, Resnick and Walker''s <b><i>Fundamentals of Physics.</i></b> This text continues to outperform the competition year after year, and the new edition will be no exception. Intended for Calculus-based Physics courses, the Sixth Edition of this extraordinary text is a major redesign of the best-selling Fifth Edition, which still maintains many of the elements that led to its enormous success. Jearl Walker adds his unique style to this edition with the addition of new problems designed to capture, and keep, students'' attention. Nearly all changes are based on suggestions from instructors and students using the Fifth Edition, from reviewer comments, and from research done on the process of learning. The primary goal of this text is to provide students with a solid understanding of fundamental physics concepts, and to help them apply this conceptual understanding to quantitative problem solving.</p><br /><table border="1" width="375" cellpadding="5"><tr><th width="50%">VERSION</th><t
h>ISBN</th
><th>CONTE
NTS</th></
tr><tr><td
valign="top">Regular Edition</td><td valign="top">0-471-32000-5
</td><td valign="top">Chapters 1?38</td></tr><tr><td valign="top">Extended Edition</td><td valign="top">0-471-33236-4
</td><td valign="top">Chapters 1?45; contains seven additional chapters on quantum physics and cosmology.</td></tr><tr><t
d valign="top">Volume 1</td><td valign="top">0-471-33235-6
</td><td valign="top">Chapters 1?21; Mechanics/Thermodynamics (Cloth)</td></tr><tr><td valign="top">Volume 2</td><td valign="top">0-471-36037-6
</td><td valign="top">Chapters 22?45; E p M and Modern Physics (Cloth)</td></tr><tr><td valign="top">Part 1</td><td valign="top">0-471-33234-8
</td><td valign="top">Chapters 1?12 (paperback)</td></tr><tr><
td valign="top">Part 2</td><td valign="top">0-471-36041-4
</td><td valign="top">Chapters 13?21 (paperback)</td></tr><tr><
td valign="top">Part 3</td><td valign="top">0-471-36040-6
</td><td valign="top">Chapters 22?33 (paperback)</td></tr><tr><
td valign="top">Part 4</td><td valign="top">0-471-36039-2
</td><td valign="top">Chapters 34?38 (paperback)</td></tr><tr><
td valign="top">Part 5</td><td valign="top">0-471-36038-4
</td><td valign="top">Chapters 39?45 (paperback)</td></tr></tab
le>'||
13 '<p>No other text on the market today can match the success of Halliday, Resnick and Walker''s <b><i>Fundamentals of Physics.</i></b> This text continues to outperform the competition year after year, and the new edition will be no exception. Intended for Calculus-based Physics courses, the Sixth Edition of this extraordinary text is a major redesign of the best-selling Fifth Edition, which still maintains many of the elements that led to its enormous success. Jearl Walker adds his unique style to this edition with the addition of new problems designed to capture, and keep, students'' attention. Nearly all changes are based on suggestions from instructors and students using the Fifth Edition, from reviewer comments, and from research done on the process of learning. The primary goal of this text is to provide students with a solid understanding of fundamental physics concepts, and to help them apply this conceptual understanding to quantitative problem solving.</p><br /><table border="1" width="375" cellpadding="5"><tr><th width="50%">VERSION</th><t
h>ISBN</th
><th>CONTE
NTS</th></
tr><tr><td
valign="top">Regular Edition</td><td valign="top">0-471-32000-5
</td><td valign="top">Chapters 1?38</td></tr><tr><td valign="top">Extended Edition</td><td valign="top">0-471-33236-4
</td><td valign="top">Chapters 1?45; contains seven additional chapters on quantum physics and cosmology.</td></tr><tr><t
d valign="top">Volume 1</td><td valign="top">0-471-33235-6
</td><td valign="top">Chapters 1?21; Mechanics/Thermodynamics (Cloth)</td></tr><tr><td valign="top">Volume 2</td><td valign="top">0-471-36037-6
</td><td valign="top">Chapters 22?45; E p M and Modern Physics (Cloth)</td></tr><tr><td valign="top1234');
14 v_dummy := DBMS_SQL.EXECUTE(v_update_
cursor);
15 DBMS_SQL.CLOSE_CURSOR(v_up
date_curso
r);
16 EXCEPTION
17 WHEN others THEN DBMS_SQL.CLOSE_CURSOR(v_up
date_curso
r); ROLLBACK; RAISE;
18* END;
SQL> /
PL/SQL procedure successfully completed.
SQL>
SQL>
SQL> get temp3.sql
1* select site_credits_html from co_working.bcs where bcs_id = 3538
SQL> /
SITE_CREDITS_HTML
--------------------------
----------
----------
----------
----------
----------
----
<p>No other text on the market today can match the success of Halliday, Resnick
and Walker's <b><i>Fundamentals of Physics.</i></b> This text continues to outpe
rform the competition year after year, and the new edition will be no exception.
Intended for Calculus-based Physics courses, the Sixth Edition of this extraord
inary text is a major redesign of the best-selling Fifth Edition, which still ma
intains many of the elements that led to its enormous success. Jearl Walker adds
his unique style to this edition with the addition of new problems designed to
capture, and keep, students' attention. Nearly all changes are based on suggesti
ons from instructors and students using the Fifth Edition, from reviewer comment
s, and from research done on the process of learning. The primary goal of this t
ext is to provide students with a solid understanding of fundamental physics con
SITE_CREDITS_HTML
--------------------------
----------
----------
----------
----------
----------
----
cepts, and to help them apply this conceptual understanding to quantitative prob
lem solving.</p><br /><table border="1" width="375" cellpadding="5"><tr><th widt
h="50%">VERSION</th><th>IS
BN</th><th
>CONTENTS<
/th></tr><
tr><td valign="top">Regu
lar Edition</td><td valign="top">0-471-32000-5
</td><td valign="top">Chapters 1?3
8</td></tr><tr><td valign="top">Extended Edition</td><td valign="top">0-471-3323
6-4</td><td valign="top">Chapters 1?45; contains seven additional chapters on qu
antum physics and cosmology.</td></tr><tr><t
d valign="top">Volume 1</td><td vali
gn="top">0-471-33235-6</td
><td valign="top">Chapters 1?21; Mechanics/Thermodynam
ics (Cloth)</td></tr><tr><td valign="top">Volume 2</td><td valign="top">0-471-36
037-6</td><td valign="top">Chapters 22?45; E p M and Modern Physics (Cloth)</td>
</tr><tr><td valign="top">Part 1</td><td valign="top">0-471-33234-8
</td><td vali
SITE_CREDITS_HTML
--------------------------
----------
----------
----------
----------
----------
----
gn="top">Chapters 1?12 (paperback)</td></tr><tr><
td valign="top">Part 2</td><td
valign="top">0-471-36041-4
</td><td valign="top">Chapters 13?21 (paperback)</td><
/tr><tr><td valign="top">Part 3</td><td valign="top">0-471-36040-6
</td><td valig
n="top">Chapters 22?33 (paperback)</td></tr><tr><
td valign="top">Part 4</td><td
valign="top">0-471-36039-2
</td><td valign="top">Chapters 34?38 (paperback)</td><
/tr><tr><td valign="top">Part 5</td><td valign="top">0-471-36038-4
</td><td valig
n="top">Chapters 39?45 (paperback)</td></tr></tab
le><p>No other text on the mark
et today can match the success of Halliday, Resnick and Walker's <b><i>Fundament
als of Physics.</i></b> This text continues to outperform the competition year a
fter year, and the new edition will be no exception. Intended for Calculus-based
Physics courses, the Sixth Edition of this extraordinary text is a major redesi
SITE_CREDITS_HTML
--------------------------
----------
----------
----------
----------
----------
----
gn of the best-selling Fifth Edition, which still maintains many of the elements
that led to its enormous success. Jearl Walker adds his unique style to this ed
ition with the addition of new problems designed to capture, and keep, students'
attention. Nearly all changes are based on suggestions from instructors and stu
dents using the Fifth Edition, from reviewer comments, and from research done on
the process of learning. The primary goal of this text is to provide students w
ith a solid understanding of fundamental physics concepts, and to help them appl
y this conceptual understanding to quantitative problem solving.</p><br /><table
border="1" width="375" cellpadding="5"><tr><th width="50%">VERSION</th><t
h>ISBN
</th><th>CONTENTS</th></tr
><tr><td valign="top">Regular Edition</td><td valign="
top">0-471-32000-5</td><td
valign="top">Chapters 1?38</td></tr><tr><td valign="t
SITE_CREDITS_HTML
--------------------------
----------
----------
----------
----------
----------
----
op">Extended Edition</td><td valign="top">0-471-33236-4
</td><td valign="top">Cha
pters 1?45; contains seven additional chapters on quantum physics and cosmology.
</td></tr><tr><td valign="top">Volume 1</td><td valign="top">0-471-33235-6
</td><
td valign="top">Chapters 1?21; Mechanics/Thermodynamics (Cloth)</td></tr><tr><td
valign="top">Volume 2</td><td valign="top">0-471-36037-6
</td><td valign="top">C
hapters 22?45; E p M and Modern Physics (Cloth)</td></tr><tr><td valign="top1234
SQL>
SQL>
SQL>
SQL>
SQL> get temp2.sql
1 DECLARE
2 v_update_cursor INTEGER;
3 v_update_stmt VARCHAR2(500);
4 v_dummy INTEGER;
5 BEGIN
6 v_update_cursor := DBMS_SQL.OPEN_CURSOR;
7 v_update_stmt :=
8 'UPDATE co_working.bcs '||
9 'SET site_credits_html = :site_credits_html '||
10 'WHERE bcs_id = 3538';
11 DBMS_SQL.PARSE(v_update_cu
rsor, v_update_stmt, DBMS_SQL.NATIVE);
12 DBMS_SQL.BIND_VARIABLE(v_u
pdate_curs
or, ':site_credits_html', '<p>No other text on the market today can match the success of Halliday, Resnick and Walker''s <b><i>Fundamentals of Physics.</i></b> This text continues to outperform the competition year after year, and the new edition will be no exception. Intended for Calculus-based Physics courses, the Sixth Edition of this extraordinary text is a major redesign of the best-selling Fifth Edition, which still maintains many of the elements that led to its enormous success. Jearl Walker adds his unique style to this edition with the addition of new problems designed to capture, and keep, students'' attention. Nearly all changes are based on suggestions from instructors and students using the Fifth Edition, from reviewer comments, and from research done on the process of learning. The primary goal of this text is to provide students with a solid understanding of fundamental physics concepts, and to help them apply this conceptual understanding to quantitative problem solving.</p><br /><table border="1" width="375" cellpadding="5"><tr><th width="50%">VERSION</th><t
h>ISBN</th
><th>CONTE
NTS</th></
tr><tr><td
valign="top">Regular Edition</td><td valign="top">0-471-32000-5
</td><td valign="top">Chapters 1?38</td></tr><tr><td valign="top">Extended Edition</td><td valign="top">0-471-33236-4
</td><td valign="top">Chapters 1?45; contains seven additional chapters on quantum physics and cosmology.</td></tr><tr><t
d valign="top">Volume 1</td><td valign="top">0-471-33235-6
</td><td valign="top">Chapters 1?21; Mechanics/Thermodynamics (Cloth)</td></tr><tr><td valign="top">Volume 2</td><td valign="top">0-471-36037-6
</td><td valign="top">Chapters 22?45; E p M and Modern Physics (Cloth)</td></tr><tr><td valign="top">Part 1</td><td valign="top">0-471-33234-8
</td><td valign="top">Chapters 1?12 (paperback)</td></tr><tr><
td valign="top">Part 2</td><td valign="top">0-471-36041-4
</td><td valign="top">Chapters 13?21 (paperback)</td></tr><tr><
td valign="top">Part 3</td><td valign="top">0-471-36040-6
</td><td valign="top">Chapters 22?33 (paperback)</td></tr><tr><
td valign="top">Part 4</td><td valign="top">0-471-36039-2
</td><td valign="top">Chapters 34?38 (paperback)</td></tr><tr><
td valign="top">Part 5</td><td valign="top">0-471-36038-4
</td><td valign="top">Chapters 39?45 (paperback)</td></tr></tab
le>'||
13 '<p>No other text on the market today can match the success of Halliday, Resnick and Walker''s <b><i>Fundamentals of Physics.</i></b> This text continues to outperform the competition year after year, and the new edition will be no exception. Intended for Calculus-based Physics courses, the Sixth Edition of this extraordinary text is a major redesign of the best-selling Fifth Edition, which still maintains many of the elements that led to its enormous success. Jearl Walker adds his unique style to this edition with the addition of new problems designed to capture, and keep, students'' attention. Nearly all changes are based on suggestions from instructors and students using the Fifth Edition, from reviewer comments, and from research done on the process of learning. The primary goal of this text is to provide students with a solid understanding of fundamental physics concepts, and to help them apply this conceptual understanding to quantitative problem solving.</p><br /><table border="1" width="375" cellpadding="5"><tr><th width="50%">VERSION</th><t
h>ISBN</th
><th>CONTE
NTS</th></
tr><tr><td
valign="top">Regular Edition</td><td valign="top">0-471-32000-5
</td><td valign="top">Chapters 1?38</td></tr><tr><td valign="top">Extended Edition</td><td valign="top">0-471-33236-4
</td><td valign="top">Chapters 1?45; contains seven additional chapters on quantum physics and cosmology.</td></tr><tr><t
d valign="top">Volume 1</td><td valign="top">0-471-33235-6
</td><td valign="top">Chapters 1?21; Mechanics/Thermodynamics (Cloth)</td></tr><tr><td valign="top">Volume 2</td><td valign="top">0-471-36037-6
</td><td valign="top">Chapters 22?45; E p M and Modern Physics (Cloth)</td></tr><tr><td valign="top12345');
14 v_dummy := DBMS_SQL.EXECUTE(v_update_
cursor);
15 DBMS_SQL.CLOSE_CURSOR(v_up
date_curso
r);
16 EXCEPTION
17 WHEN others THEN DBMS_SQL.CLOSE_CURSOR(v_up
date_curso
r); ROLLBACK; RAISE;
18* END;
SQL> /
PL/SQL procedure successfully completed.
SQL>
SQL>
SQL> get temp3.sql
1* select site_credits_html from co_working.bcs where bcs_id = 3538
SQL> /
SITE_CREDITS_HTML
--------------------------
----------
----------
----------
----------
----------
----
SQL> spool off
Start Free Trial
