ERROR EXECUTE IMMEDIATE
Publicado por Alfredo (17 intervenciones) el 10/12/2008 20:23:49
Hola , tengo un problema al Utilizar el EXECUTE IMMEDIATE me podrian ayudar
DECLARE
sql_stmt VARCHAR2(200);
plsql_block VARCHAR2(500);
v_tabla VARCHAR2(50);
BEGIN
v_tabla := 'Doc' || '134';
BEGIN
EXECUTE IMMEDIATE 'CREATE TABLE BNXAFILIACION.'||v_tabla||'(DocId NUMBER CONSTRAINT PK_'||v_tabla||
' PRIMARY KEY USING INDEX TABLESPACE BNX_AFILIACION_IDX CONSTRAINT FK_'||v_tabla||
'_DIGITALIZAMAIN REFERENCES BNXAFILIACION.DIGITALIZAMAIN(DocID) NOT NULL,fecha_ingreso DATE NOT NULL )
TABLESPACE BNXAFILIACION STORAGE (INITIAL 6144 NEXT 6144 MINEXTENTS 1 MAXEXTENTS 5 );';
EXCEPTION
WHEN OTHERS THEN
IF TO_CHAR(SQLCODE) = '-2260'
THEN
NULL; -- ignore this error.
END IF;
END;
me manda este error
ORA-06550: línea 56, columna 5:
PLS-00103: Se ha encontrado el símbolo "end-of-file" cuando se esperaba uno de los siguientes:
( begin case declare end exception exit for goto if loop mod
null pragma raise return select update while with
<an identifier> <a double-quoted delimited-identifier>
<a bind variable> << continue close current delete fetch lock
insert open rollback savepoint set sql execute commit forall
merge pipe purge
DECLARE
sql_stmt VARCHAR2(200);
plsql_block VARCHAR2(500);
v_tabla VARCHAR2(50);
BEGIN
v_tabla := 'Doc' || '134';
BEGIN
EXECUTE IMMEDIATE 'CREATE TABLE BNXAFILIACION.'||v_tabla||'(DocId NUMBER CONSTRAINT PK_'||v_tabla||
' PRIMARY KEY USING INDEX TABLESPACE BNX_AFILIACION_IDX CONSTRAINT FK_'||v_tabla||
'_DIGITALIZAMAIN REFERENCES BNXAFILIACION.DIGITALIZAMAIN(DocID) NOT NULL,fecha_ingreso DATE NOT NULL )
TABLESPACE BNXAFILIACION STORAGE (INITIAL 6144 NEXT 6144 MINEXTENTS 1 MAXEXTENTS 5 );';
EXCEPTION
WHEN OTHERS THEN
IF TO_CHAR(SQLCODE) = '-2260'
THEN
NULL; -- ignore this error.
END IF;
END;
me manda este error
ORA-06550: línea 56, columna 5:
PLS-00103: Se ha encontrado el símbolo "end-of-file" cuando se esperaba uno de los siguientes:
( begin case declare end exception exit for goto if loop mod
null pragma raise return select update while with
<an identifier> <a double-quoted delimited-identifier>
<a bind variable> << continue close current delete fetch lock
insert open rollback savepoint set sql execute commit forall
merge pipe purge
Valora esta pregunta


0