export user objects generates invalid scripts

[Desmond Tong]

Two types of errors occur when the objects are exported by 'Export User Objects' in PL/SQL Developer 7.0.1 and 6.0.6

1) On views, extra brackets and fields added between "WITH OBJECT OID" and "AS".
e.g.
prompt
prompt Creating view BREAK_VW
prompt ======================
prompt
CREATE OR REPLACE VIEW BREAK_VW OF rsc_break_typ WITH OBJECT OID (for_resource)
(for_resource, for_override, breaks)
AS
SELECT
r.resource_id AS for_resource,
op.override_period_id AS for_schedule,
CAST ( MULTISET(
SELECT break_typ(
opb.starts,
opb.ends)
FROM rws_override_period_brk opb
WHERE op.override_period_id = opb.for_override_period
ORDER BY opb.starts
) AS break_tab)
FROM lab_resource_vw r, rws_override_period op
/

2) On tables, an empty line added before "cache".
e.g.
prompt
prompt Creating table TMP_ABC
prompt ======================
prompt
create table TMP_ABC
(
COL1 NUMBER(10),
COL2 VARCHAR2(10)
)

cache;

Since I am using the 'Export User Objects' every week to prepare the database build, that will be great if these problems can be resolved ASAP.

Thanks!

Desmond

 

[Marco Kalter]

We'll fix it.