OraFAQ Forum: Spanish » EXECUTE IMMEDIATE ORACLE FORMS 10G

Home » Non-English Forums » Spanish » EXECUTE IMMEDIATE ORACLE FORMS 10G (Forms Builder 32bits versión 10.1.2.0.2, Windows XP)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

EXECUTE IMMEDIATE ORACLE FORMS 10G [message #668674]

Thu, 08 March 2018 18:36

einsen
Messages: 2
Registered: March 2018

Junior Member

Buen día, estoy tratando de habilitar y/o deshabilitar algunos triggers desde un botón en Oracle Forms, sin embargo me devuelve el siguiente error:

Error 591 esta función no está soportada en programas instalados en el cliente

el query es el siguiente:

BEGIN
IF :BK_TRIGGERS.TRGTIPOSDESEGURO = 'S' THEN
EXECUTE IMMEDIATE 'ALTER TRIGGER TRG_UPDEL_TIPOSDESEGURO ENABLE';
MESSAGE('HOLA');
MESSAGE(' ');
END IF;
END;

De antemano gracias

Atentamente

Report message to a moderator

Re: EXECUTE IMMEDIATE ORACLE FORMS 10G [message #668675 is a reply to message #668674]

Thu, 08 March 2018 22:40

Barbara Boehmer
Messages: 8922
Registered: November 2002
Location: California, USA

Senior Member

BEGIN
  IF :BK_TRIGGERS.TRGTIPOSDESEGURO = 'S' THEN
    FORMS_DDL('ALTER TRIGGER TRG_UPDEL_TIPOSDESEGURO ENABLE');
    MESSAGE('HOLA');
    MESSAGE(' ');
  END IF;
END;

Report message to a moderator

Re: EXECUTE IMMEDIATE ORACLE FORMS 10G [message #668693 is a reply to message #668675]

Fri, 09 March 2018 10:07

einsen
Messages: 2
Registered: March 2018

Junior Member

Muchas gracias por tu ayuda Barbara!
Thank you very much for your help Barbara!

Report message to a moderator

Previous Topic:	Ayuda con webutil
Next Topic:	EJECUTAR SQLPLUS DESDE ORACLE FORMS

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Mar 05 11:23:05 CST 2021