SqlDbx
You are not logged in.
Pages: 1
Is there an option to set a delimiter for each generated script?
For example, for Oracle each script should end with ";"
I'm making a backup of the whole schema, but so far scripts for every object just ends with a blank line, so Oracle marks all of it as errors.
So it goes
DROP TABLE ; -- for some reason drop ends with ";"
CREATE TABLE
CREATE INDEX
GRANT
Without any ";" in between
----------
Another bug:
DROP FUNCTION/PACKAGE/PROCEDURE/SYNONYM GARBUYA.GARBUYA.FN_TEST; -- double schema name
CREATE FUNCTION/PACKAGE/PROCEDURE/SYNONYM FN_TEST -- no schema name even if it is specified in options
SEQUENCE does not have such problems
Last edited by garbuya (2014-08-12 10:55:58)
Offline
We can not reproduce some of the issues you mention.
Would be great if you can email to support with steps to reproduce.
Also can you please include your Options->Scripting/Log and Tools->Generate Scripts screenshots
Offline
Just sent you an email with the screen prints
Hope it helps
Database Oracle 11g v1
Last edited by garbuya (2014-08-21 10:24:39)
Offline
Just tested it with version 4.4.1 to generate scripts in Oracle 11G
There is is a problem with CREATE statement.
CREATE TABLE is OK, but for other objects sometimes the CREATE statement has only closing double quote.
It looks like if:
- there is unbalanced open bracket in the middle of 1st line
- 1st line ends with closing bracket
- open bracket is alone on 2nd line
- 2nd line is blank
then it will be a closing double quote after object name
Here some examples of good and bad:
CREATE FUNCTION F_ATTACHMENT_EXIST" (p_spcl_bill_id -- unbalanced open bracket in the middle of 1st line
sis_spcl_bill_attch.sis_spcl_bill%TYPE)
CREATE FUNCTION FN_ADD_COP_DNI
( p_cmpny_vndr_nbr
, p_prod_nbr
CREATE FUNCTION FN_BA_TBL_COPY" (v_batch_name IN varchar2) --1st line ends with closing bracket
RETURN number
CREATE FUNCTION FN_GATHER_STATISTIC" -- open bracket is alone on 2nd line
(
P_OWNER IN VARCHAR2
CREATE FUNCTION CASADM.FN_IS_DATE
( P_DATE IN VARCHAR2
CREATE FUNCTION CASADM.FN_IS_NUMBER
(p in varchar2)
CREATE FUNCTION CASADM.FN_LONG_TO_CHAR (P_LONG LONG) RETURN VARCHAR2
CREATE FUNCTION CASADM.FN_NEXT_GRP" -- 2nd line is blank
blank line
( p_record_type VARCHAR2 )
CREATE FUNCTION CASADM.FN_NEXT_VAL (
p_record_type VARCHAR2 ,
CREATE PACKAGE CASADM.CAS_APPR_ACCR_PMT_PKG" AS -- 2nd line is blank
blank line
CREATE PACKAGE CASADM.CAS_BA_COMM_PKG
IS
CREATE PACKAGE CASADM.cas_ba_copy_accruals_pkg
as
CREATE PROCEDURE CAS_AP_VEND_SEL" ( -- 2nd line is blank
blank line
CREATE PROCEDURE CASADM.CAS_CMPNY_VEND_SEL (
CMPNYVENDCURSOR
Offline
Pages: 1