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
Ken
Messages: 50
Registered: April 1998
Member
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
IDENTIFYED BY username
TEMPORARY TABLESPACE temp;

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
works.

Hope it helps.

Regards,

Frank
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