APRESS.COM : Expert Oracle Database Architecture: 9<i>i</i> and 10<i>g</i> Programming Techniques and Solutions : 9781590595305

Expert Oracle Database Architecture: 9<i>i</i> and 10<i>g</i> Programming Techniques and Solutions book cover

By Thomas Kyte
ISBN13: 978-1-59059-530-5
ISBN10: 1-59059-530-0
768 pp.
Published Sep 2005
Print Book Price: $49.99
eBook Price: $34.99

My eBook

Errata Submission

If you think that you've found an error in Expert Oracle Database Architecture: 9i and 10g Programming Techniques and Solutions, please let us know about it. You will find any confirmed erratum below, so you can check if your concern has already been addressed.

Submit Errata

Errata

Issue	Author's Response
in SET SQL*Plus'AUTOTRACE: （4）TO RUN CREATE PUBLIC SYNONYM PLAN_TABLE FOR PLAN_TABLE; ORA-00955 Name from the use of existing objects	that just means "someone else already did that", it is just saying 'public synonym already exists'
SETTING UP YOUR ENVIRONMENT Page : xxxv ops$tkyte@ORA10GR1> begin 2 for x in ( select * from big_table.big_table ) 3 loop 4 insert into t2 values X; 5 end loop; 6 commit; 7 end; 8 / commit; * ERROR at line 6: ORA-06550: line 6, column 8: PLS-00103: Encountered the symbol "end-of-file" when expecting one of the follow ing: begin case declare end exception exit for goto if loop mod null pragma raise return select update while with <an identifier> <a double-quoted delimited-identifier> <a bind variable> << close current delete fetch lock insert open rollback savepoint set sql execute commit forall merge pipe	that code absolutely works. If you provide a true cut and paste from sqlplus - I'll be glad to take a look. But this is very simple code, very basic. I cut and pasted your example and it worked straight away ops$tkyte%ORA10GR2> create table t2 as select * from big_table.big_table where 1=0; Table created. ops$tkyte%ORA10GR2> ops$tkyte%ORA10GR2> begin 2 for x in ( select * from big_table.big_table ) 3 loop 4 insert into t2 values X; 5 end loop; 6 commit; 7 end; 8 / PL/SQL procedure successfully completed. You must have a typo in your example somehow.

Issue

Author's Response

in SET SQL*Plus'AUTOTRACE:
（4）TO RUN CREATE PUBLIC SYNONYM PLAN_TABLE FOR PLAN_TABLE;

ORA-00955
Name from the use of existing objects

that just means "someone else already did that", it is just saying 'public synonym already exists'

SETTING UP YOUR ENVIRONMENT
Page : xxxv

ops$tkyte@ORA10GR1> begin
2 for x in ( select * from big_table.big_table )
3 loop
4 insert into t2 values X;
5 end loop;
6 commit;
7 end;
8 /

commit;
*
ERROR at line 6:
ORA-06550: line 6, column 8:
PLS-00103: Encountered the symbol "end-of-file" when expecting one of the follow
ing:
begin case declare end exception exit for goto if loop mod
null pragma raise return select update while with
<an identifier> <a double-quoted delimited-identifier>
<a bind variable> << close current delete fetch lock insert
open rollback savepoint set sql execute commit forall merge
pipe

that code absolutely works. If you provide a true cut and paste from sqlplus - I'll be glad to take a look.

But this is very simple code, very basic. I cut and pasted your example and it worked straight away

ops$tkyte%ORA10GR2> create table t2 as select * from big_table.big_table where 1=0;

Table created.

ops$tkyte%ORA10GR2>
ops$tkyte%ORA10GR2> begin
2 for x in ( select * from big_table.big_table )
3 loop
4 insert into t2 values X;
5 end loop;
6 commit;
7 end;
8 /

PL/SQL procedure successfully completed.

You must have a typo in your example somehow.