Home » Developer & Programmer » Forms » pls explain me how to use form_ddl (form 9i, oracle 9i, win xp)
pls explain me how to use form_ddl [message #405646] Thu, 28 May 2009 21:06 Go to next message
aiznu
Messages: 24
Registered: May 2009
Junior Member
hi anyone can explain me how to use form_ddl..
i understand it use for DDL.
BEGIN Forms_DDL('create role emp');
IF NOT Form_Success THEN
Message ('Role Creation Failed');
ELSE Message ('Role Created');
END IF;
END;

this syntax to create the table but i want to create using user enter the name of role.how can i do?

BEGIN Forms_DDL('create role'|| :block2.ro);
IF NOT Form_Success THEN
Message ('Role Creation Failed');
ELSE Message ('Role Created');
END IF;
END;
why i run this coding, it's error..
please help me
Re: pls explain me how to use form_ddl [message #405670 is a reply to message #405646] Thu, 28 May 2009 23:56 Go to previous messageGo to next message
vamsi kasina
Messages: 2112
Registered: October 2003
Location: Cincinnati, OH
Senior Member
error?? where it is?
How should we know what kind of error you are getting?
Quote:
BEGIN Forms_DDL('create role'|| :block2.ro);
Anyway, do you think there is a space missing after role?

By
Vamsi
Re: pls explain me how to use form_ddl [message #405676 is a reply to message #405670] Fri, 29 May 2009 00:15 Go to previous message
aiznu
Messages: 24
Registered: May 2009
Junior Member
Embarassed ok.. Shocked i think now i understand..
the syntax must same like DDL syntax in database command includng space.
thanks vamsi for help me
Previous Topic: How to create a Stacked Canvas in a TAB Canvas?
Next Topic: how to make text item as non navigable
Goto Forum:
  


Current Time: Thu Dec 05 01:44:22 CST 2024