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