Home » Developer & Programmer » Forms » Unable to use Dynamic SQL in Oracle Forms 5
Unable to use Dynamic SQL in Oracle Forms 5 [message #82171] Thu, 01 May 2003 05:21 Go to next message
Suddha Satta Ray
Messages: 5
Registered: February 2002
Junior Member
Hi,

I am unable to compile a code I have written in WHEN-BUTTON-PRESSED trigger which contains the use of the package DBMS_SQL (like DBMS_SQL.PARSE, DBMS_SQL.OPEN etc.)

When I press on the compile button, I get the following error:

object SYS.DBMS_SQL is invalid

Kindly help.

Thanks in advance,

S S Ray
India

Report message to a moderator

Re: Unable to use Dynamic SQL in Oracle Forms 5 [message #82185 is a reply to message #82171] Fri, 02 May 2003 12:51 Go to previous message
Govardhan Parthasarathy
Messages: 1
Registered: May 2003
Junior Member
Hi,

For executing Dynamic SQL in forms we should use
FORMS_DDL package which works similar to DBMS_SQL.

Regs,
Govardhan
US

Report message to a moderator

Previous Topic: order of triggers fire
Next Topic: add a field which i type in urdu
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Jan 31 11:19:18 CST 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.