From: "Thomas Reinartz" <Thomas.Reinartz@debis.com>
Subject: Re: CREATE USER
Date: 2000/05/05
Message-ID: <8eufvh$4p7$1@news.sns-felb.debis.de>#1/1
References: <3912baef@news.waldonet.ent.mt>
X-MimeOLE: Produced By Microsoft MimeOLE V4.72.2106.4
X-Complaints-To: news@sns-felb.debis.de
X-Trace: news.sns-felb.debis.de 957530929 4903 53.122.101.2 (5 May 2000 12:48:49 GMT)
Organization: InterNetNews debis Systemhaus
NNTP-Posting-Date: 5 May 2000 12:48:49 GMT
Newsgroups: comp.databases.oracle.tools


Hi,

I don't know if it helps, but did you try to parse it in one go? Like this:

DBMS_SQL.PARSE(cid, 'CREATE USER ' || usr_name || ' IDENTIFIED BY ' ||
usr_pass || ' Profile ' || usr_role, dbms_sql.v7);

cheers,

Thomas