Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> dbms_repcat.execute_ddl

dbms_repcat.execute_ddl

From: Maija-Leena Kangasmäki <maija-leena.kangasmaki_at_tieto.com>
Date: Mon, 28 Dec 1998 13:15:00 GMT
Message-ID: <3687840C.776B3A6B@tieto.com>


Hi,
I have a weird problem. There are two execute_ddl -procedures in dbms_repcat -package in my database. And when I try to run it, I get error PLS-307. What should I do ?

Regards,

Maija-Leena

LNTVR_SQL>
execute dbms_repcat.execute_ddl('...');

      *
VIRHE rivillä 1:

ORA-06550: rivi 1, sarake 7:
PLS-00307: liian monta 'EXECUTE_DDL':n esittelyä vastaa tätä kutsua
ORA-06550: rivi 1, sarake 7:

PL/SQL: Statement ignored

LNTVR_SQL> DESC DBMS_REPCAT.EXECUTE_DDL PROCEDURE DBMS_REPCAT.EXECUTE_DDL

 Argumentin nimi                Tyyppi                  Sy/Tu  Oletus?

------------------------------ ----------------------- ------ --------
GNAME VARCHAR2 IN DEFAULT MASTER_LIST VARCHAR2 IN DEFAULT DDL_TEXT VARCHAR2 IN SNAME VARCHAR2 IN DEFAULT PROCEDURE DBMS_REPCAT.EXECUTE_DDL Argumentin nimi Tyyppi Sy/Tu Oletus?
------------------------------ ----------------------- ------ --------
GNAME VARCHAR2 IN DEFAULT MASTER_TABLE TABLE OF VARCHAR2(128) IN DDL_TEXT VARCHAR2 IN SNAME VARCHAR2 IN DEFAULT
LNTVR_SQL> Received on Mon Dec 28 1998 - 07:15:00 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US