41: drop_sequence instead of create
42: -- bridgway 11/29/00
43: */
44:
45: ad_ddl.do_ddl(out_oracle_schema, 'OFA',
46: ad_ddl.drop_sequence,
47: 'drop sequence ' || X_name,X_name);
48: end if;
49:
42: -- bridgway 11/29/00
43: */
44:
45: ad_ddl.do_ddl(out_oracle_schema, 'OFA',
46: ad_ddl.drop_sequence,
47: 'drop sequence ' || X_name,X_name);
48: end if;
49:
50: ad_ddl.do_ddl(out_oracle_schema, 'OFA',
46: ad_ddl.drop_sequence,
47: 'drop sequence ' || X_name,X_name);
48: end if;
49:
50: ad_ddl.do_ddl(out_oracle_schema, 'OFA',
51: ad_ddl.create_sequence,
52: 'create sequence ' ||
53: X_name ||
54: ' start with ' ||
47: 'drop sequence ' || X_name,X_name);
48: end if;
49:
50: ad_ddl.do_ddl(out_oracle_schema, 'OFA',
51: ad_ddl.create_sequence,
52: 'create sequence ' ||
53: X_name ||
54: ' start with ' ||
55: to_char(X_start_num) ||