SqlDbx Forum

SqlDbx

You are not logged in.

#1 2014-08-12 10:02:58

garbuya
Member

Bugs in "Generate Database Scripts"

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

#2 2014-08-13 09:29:20

sqldbxhelp
Administrator

Re: Bugs in "Generate Database Scripts"

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

#3 2014-08-21 10:00:18

garbuya
Member

Re: Bugs in "Generate Database Scripts"

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

#4 2014-09-17 09:47:25

garbuya
Member

Re: Bugs in "Generate Database Scripts"

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

Board footer

Powered by FluxBB