OraFAQ Forum: Forms » Dynamic SQL

Home » Developer & Programmer » Forms » Dynamic SQL

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

Dynamic SQL [message #133673]

Sun, 21 August 2005 07:00

rzkhan
Messages: 370
Registered: March 2005

Senior Member

Hi All. I am using the following statement in when_button_pressed trigger.

begin
EXECUTE IMMEDIATE 'CREATE TABLE bonus (id NUMBER, amt NUMBER)';
end;

it throw an error. while at sql prompt it works fine. m using 8i,win2k,forms6i. plz help..
Riaz

Report message to a moderator

Re: Dynamic SQL [message #133676 is a reply to message #133673]

Sun, 21 August 2005 08:10

sudhir.sukumar
Messages: 52
Registered: August 2005
Location: India

Member

I dont think what you are trying to do is possible. You can perform navigation and perform calculations at item, block or form level with when_button_pressed trigger.

Instead use, FORMS_DDL built-in procedure to achieve the same.

regs.

Report message to a moderator

Re: Dynamic SQL [message #133709 is a reply to message #133676]

Sun, 21 August 2005 19:32

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia

Senior Member
Account Moderator

Quote:

FORMS_DDL examples

Example 1
/*
** Built-in: FORMS_DDL
** Example: The expression can be a string literal.
*/
BEGIN
  Forms_DDL('create table temp(n NUMBER)');
  IF NOT Form_Success THEN
    Message ('Table Creation Failed');
  ELSE
    Message ('Table Created');
  END IF;
END;

David

Report message to a moderator

Previous Topic:	Mail through forms 6i
Next Topic:	Forms triggers reference

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 20 12:54:47 CDT 2024