Re: DDL_TEXT prob. using default value w/ DBMS_REPCAT_ALTER_MASTER_REPOBJECT

Never mind. Here's the solution:

BEGIN
> DBMS_REPCAT.ALTER_MASTER_REPOBJECT (
> sname => 'SCOTT',
> oname => 'EMP',
> type => 'TABLE',
> ddl_text => 'ALTER TABLE scott.emp
> ADD (flag VARCHAR2(1) DEFAULT ''N'')'
> );
> END;
> /

daniel.navarro_at_intervoice-brite.com (Daniel N.) wrote in message news:<2a49a9a4.0111191555.910de94_at_posting.google.com>...
> Does anyone know what the proper syntax for quotes when using DDL_TEXT
> statements? I have the following code and can't get the string to
> execute, because I have to use a single quote when I use the DEFAULT
> tag for a character.
> Here's my code:
>
> BEGIN
> DBMS_REPCAT.ALTER_MASTER_REPOBJECT (
> sname => 'SCOTT',
> oname => 'EMP',
> type => 'TABLE',
> ddl_text => '"ALTER TABLE scott.emp
> ADD (flag VARCHAR2(1) DEFAULT 'N')"'
> );
> END;
> /
>
> How do I tell Oracle to ignore the single quotes around the default
> value "N"
> and continue with the statement?
>
> TIA,
> Dan N.
Received on Wed Nov 21 2001 - 13:28:43 CST