7.1.3 bug - Create Table Syntax error?

[Stew Stryker]

I was just creating a new table, right-clicked on Tables in Browser and filled in the form. I happened to View SQL and saw the following. This was copied directly from the View SQL.

I'm sorry to say that I can't reproduce this!

-- Create table
create table and_pw_reset_log
(
  session_id    varchar2(10) not null,
  and_name      varchar2(60) not null,
  school_code   varchar2(5),
  class_year    varchar2(4),
  advance_id    varchar2(10),
  email_addr    varchar2(100),
  outcome       varchar2(30),
  reset_details clob
)
S
D
tablespace WORKSPACE
  storage
  (
    initial 512K
    next 1M
    minextents 5
    maxextents 512
    pctincrease 50
  );
-- Add comments to the columns
comment on column and_pw_reset_log.session_id
  is 'Uniquely identifies web session, based on sequence';
comment on column and_pw_reset_log.and_name
  is 'AND user name, or calculated from web form';
comment on column and_pw_reset_log.school_code
  is 'School value from web form';
comment on column and_pw_reset_log.class_year
  is 'Class year from web form';
comment on column and_pw_reset_log.advance_id
  is 'Value if name found in AND or Advance';
comment on column and_pw_reset_log.email_addr
  is 'Change confirmation email address, if sent';
comment on column and_pw_reset_log.outcome
  is 'Success/Failure';
comment on column and_pw_reset_log.reset_details
  is 'Details of failure or success';
-- Grant/Revoke object privileges
grant select, insert, update, delete, references on and_pw_reset_log to stew;

 

[Marco Kalter]

I cannot reproduce this. Do you have a reproducible case?