Re: Create user via stored proc/package ?

Issuing a DDL statement forces a commit....try this

open 2 sql*plus sessions as the same user

In session 1..

create table test_ddl_commit (col1 number ); insert into test_ddl_commit values( 1 );

In session 2..

select * from test_ddl_commit;

no rows selected

In session 1..

create table test_ddl_commit2( col1 number );

In session 2..

select * from test_ddl_commit;

col1

There you go...the ddl statement in session 1 forced a commit..

--
Cheers

Steve Bright

steve.bright_at_capgemini.co.uk

Marc Mazerolle wrote in message <377A67EA.DBDEB27A_at_sympatico.ca>...
>Does issuing a DDL statement force a commit ? Or is it only the FORMS_DDL
that
>does this ?
>
>Marc
>
>Jens Loebling wrote:
>
>> Steve B schrieb:
>> >
>> > You can use the DBMS_SQL package to write dynamic sql statements,
including
>> > DDL..
>> >
>> > Note : Since you will be running these statements from within stored
>> > procedures then grant create / alter user etc must be expicitly granted
to
>> > the user running the procedures, and not granted via roles..
>> >
>> > hope this helps
>> >
>> > Cheers
>> >
>> > Steve Bright
>> >
>> > steve.bright_at_capgemini.co.uk
>> >
>> > Adrian Harrison wrote in message

<3779f20e.11439609_at_news.globalnet.co.uk>...
>> > >Using VB6 Enterprise & Oracle 7.34
>> > >
>> > >Is it possible to use "CREATE USER", "ALTER USER" etc.. statements in
a
>> > stored procedure or package
>> > >so that I can call them from my program thereby providing full user
>> > maintainence ?
>> > >
>> > >If not what's the best I can achieve?
>> > >
>> > >Thanks
>> > >
>> > >Adrian Harrison
>>
>> Hallo Adrian
>>
>> be careful with this point because DDL commands
>> have a implicit commit
>>
>> Jens
>
>
>
Received on Thu Jul 01 1999 - 04:38:33 CDT