DBMS_SQL

From: Tao Zhang <Tao.Zhang_at_digital-dispatch.com>
Date: 2000/07/12
Message-ID: <smq0ku6gnd6145@corp.supernews.com>#1/1

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 Received on Wed Jul 12 2000 - 00:00:00 CDT