Re: DBMS_SQL

I found this on 8i manuals (PL/SQL Packages)

"PARSE Procedure
This procedure parses the given statement in the given cursor. All statements are
parsed immediately. In addition, DDL statements are run immediately when parsed."

Try building the SQLstmt without bind variables  (||v_user ||v_passwd)

--
be happy

Eugenio
remove _nospam from reply address

Opinions are mine and do not necessarily reflect those of my company

=======================================================
Tao Zhang wrote in message ...


>Hi everybody,

>

>I was trying to use DBMS_SQL to create user and I got this error message:

>ORA-01935: missing user or role name

>This is what I got when debugging to PARSE statment (Oracle 8.1.6 on NT ).

>

>            v_passwd := '3';

>            v_user :='FF1';

>            v_cursor_id := DBMS_SQL.OPEN_CURSOR;

>            v_stmt := 'create user :u identified by :p default tablespace

>USR temporary tablespace TEMPORARY;';

>

>            DBMS_SQL.PARSE(v_cursor_id,v_stmt,DBMS_SQL.NATIVE);

>            DBMS_SQL.BIND_VARIABLE(v_cursor_id,':u',v_user);

>            DBMS_SQL.BIND_VARIABLE(v_cursor_id,':p',v_passwd);

>            v_dummy := DBMS_SQL.EXECUTE(v_cursor_id);

>            DBMS_SQL.CLOSE_CURSOR(v_cursor_id);

>

>Thanks!

>James

>

>

>