| creating a new user in the database using forms [message #77735] |
Thu, 08 November 2001 09:36  |
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  |
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.
----------------------------------------------------------------------
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
