creating a user within a function

[brig]

Hi, I am new to sql, so I apologize in advance. I wrote a procedure which calls a function. (I am not sure if the procedure will work yet). MY question is on the function. I am not sure I wrote it correctly as it gives me the Error(10,6): PLS-00103: Encountered the symbol "CREATE" ..
Can you create a user in a function? The procedure reads acct names and passwords from a table, then while its not at the end it creates a user. (calls a function to do so, as creating a user inside the procedure wouldn't work). I am lost. Here is the function, any help is appreciated.

CREATE OR REPLACE
FUNCTION MakeUSER(vchACCOUNName IN varchar2,
vchPasswordNmbrin IN varchar2)
RETURN int
AS
BEGIN

DBMS_OUTPUT.PUT_LINE('hey');--testing with begin

CREATE USER vchACCOUNName
IDENTIFIED BY vchPasswordNmbr
DEFAULT TABLESPACE STUDENTTABLESPACE
QUOTA 10M ON example
QUOTA 10M ON system;
--return 0; NOT SURE IF NEEDED

END;

[holdingbe]

Hi, I am new to sql, so I apologize in advance. I wrote a procedure which calls a function. (I am not sure if the procedure will work yet). MY question is on the function. I am not sure I wrote it correctly as it gives me the Error(10,6): PLS-00103: Encountered the symbol "CREATE" ..
Can you create a user in a function? The procedure reads acct names and passwords from a table, then while its not at the end it creates a user. (calls a function to do so, as creating a user inside the procedure wouldn't work). I am lost. Here is the function, any help is appreciated.

CREATE OR REPLACE
FUNCTION MakeUSER(vchACCOUNName IN varchar2,
vchPasswordNmbrin IN varchar2)
RETURN int
AS
BEGIN

DBMS_OUTPUT.PUT_LINE('hey');--testing with begin

CREATE USER vchACCOUNName
IDENTIFIED BY vchPasswordNmbr
DEFAULT TABLESPACE STUDENTTABLESPACE
QUOTA 10M ON example
QUOTA 10M ON system;
--return 0; NOT SURE IF NEEDED

END;

Hi friend,
Kindly understand the user concepts. create user must be create under the dba.what u did means,function or procedure created under the any user.please you login in system/manager and then create a user.