Home » Developer & Programmer » Forms » creating a new user in the database using forms
creating a new user in the database using forms [message #77735] Thu, 08 November 2001 09:36 Go to next message
Messages: 50
Registered: April 1998
I am trying to create a form to create a new user in the database, currently when it is done, I would go into sql plus and execute this statement:

CREATE USER username

When I tried to do this in forms I created a procedure with the same statement in it but I keep getting an error: 103 CREATE is an unsupported reserved word.

If anybody knows how to get around this, or any insight on what the error actually means it would be helpful.

Thank You

Re: creating a new user in the database using forms [message #77738 is a reply to message #77735] Thu, 08 November 2001 20:03 Go to previous message
Frank Chileshe
Messages: 7
Registered: November 2001
Junior Member
Hello Ken,

Forms does NOT support execution of Data Definition Language statement (DDL) directly. However,
you can use the FORMS_DDL buit in package
to execute DDL from within forms. Try the following
sample code :

forms_ddl('create user '||:blockname.username||' identified by '||:block.username);

I have used that built package several times
to issue execute DDL statements and it always

Hope it helps.


Business Solutions Mgr
CopperNET Solutions Zambia.

Previous Topic: get just number value
Next Topic: radio_group/get selected button
Goto Forum:

Current Time: Mon Aug 10 04:05:21 CDT 2020