We help IT Professionals succeed at work.

CLOB problems - Oracle bug?

hooker042299
hooker042299 asked
on
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>ISBN</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><td 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></table><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><th>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_cursor, v_update_stmt, DBMS_SQL.NATIVE);
 12                    DBMS_SQL.BIND_VARIABLE(v_update_cursor, ':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><th>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="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><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">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></table>'||
 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><th>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="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><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">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_update_cursor);
 16              EXCEPTION
 17                    WHEN others THEN DBMS_SQL.CLOSE_CURSOR(v_update_cursor); 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>ISBN</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><td 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></table><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><th>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_cursor, v_update_stmt, DBMS_SQL.NATIVE);
 12                    DBMS_SQL.BIND_VARIABLE(v_update_cursor, ':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><th>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="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><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">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></table>'||
 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><th>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="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><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">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_update_cursor);
 16              EXCEPTION
 17                    WHEN others THEN DBMS_SQL.CLOSE_CURSOR(v_update_cursor); 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



Comment
Watch Question

what are you doing?
The varchar2(4000) is the limitation of the dbms_sql procedure. For manipulation of a CLOB, use the DBMS_LOB package.
E.g. When u want to load a XML-file in a table:
1: insert a handle
 INSERT INTO xml_container
    (id,text)
  VALUES
    ( just_a_sequence.nextval
    , EMPTY_CLOB()
    )
  returning text  , id
  INTO      l_clob, l_id;

2:  Create a bfile-handle
l_xmlfile := BFILENAME(UPPER(p_directory), l_bestand);

3: Open the bfile and fill the CLOB
  DBMS_LOB.fileOpen(l_xmlfile);
  IF ( DBMS_LOB.fileIsOpen(l_xmlfile) = 1 )
  THEN
    DBMS_LOB.LOADFROMFILE(l_clob,l_xmlfile, l_size);
    DBMS_LOB.FILEClOSE(l_xmlfile);
  END IF;

And there is so much more good stuff in DBMS_LOB

Hope this helps

Edwin

Author

Commented:
Thanks for your answer.

Unfortunately, it doesn't help me much.

From another part of the application, the user is inserting any length of html into this column.
When they press save, I need to save it surprisingly.
The details of the other part of the application are unimportant. I just need a piece of sql to save it.

Your example doesn't really apply.
Can you suggest a sql statement that will update the html in temp2.sql into a CLOB column?
Commented:
If you need to dynamically save any length of data the user types, have you considered using
EXECUTE IMMEDIATE vs. DBMS_SQL.  

e.g.,
 v_update_stmt := 'UPDATE co_working.bcs '||
                                    'SET    site_credits_html  = :1 '||
                                      'WHERE  bcs_id             = 3538 ';
  EXECUTE IMMEDIATE v_update_stmt
                     USING  '<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><th>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="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><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">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></table>'||
                     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><th>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="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><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">Chapters 22?45; E p M and Modern Physics (Cloth)</td></tr><tr><td
                     valign="top12345' ;

Author

Commented:
That works - great, thanks.

I don't need to use dynamic sql, but I was trying it after reading Oracle Metalink stuff 'cos a simple update didn't work.

Explore More ContentExplore courses, solutions, and other research materials related to this topic.