pls explain me how to use form_ddl [message #405646] |
Thu, 28 May 2009 21:06 |
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
|
|
|
|
|