|
[oracle-l]
||
[Date Prev]
[12-2007 Date Index]
[Date Next]
||
[Thread Prev]
[12-2007 Thread Index]
[Thread Next]
how to create user from pl/sql in 8.0.6 version
- From: Remigiusz Sokolowski <rems@xxxxxxxx>
- To: 'ORACLE-L' <oracle-l@xxxxxxxxxxxxx>
- Date: Mon, 03 Dec 2007 13:23:22 +0100
hi!
does anybody know is this possible to create user from pl/sql level?
I mean 8.0.6 version here on windows
AFAIK there is no execute immediate yet and we haven't found any package,
which would seem to do such a thing.
What I think would work is
- create sql script with UTL_FILE
- use some os scheduler to run it and delete it after
As You see however - it is very poor solution - any other thoughts?
Best regards
Remigiusz
--
------------------------------------------------------------------------
Remigiusz Sokolowski <rems@xxxxxxxx>
WP/PTI/DIP/ZAB (+04858) 52 15 770
MySQL v04.x,05.x; Oracle v10.x
Zastrzezenia:
1. Wylaczenie danej funkcjonalnosci oznacza, ze niezwlocznie przystapimy
lub juz pracujemy nad jej uruchomieniem
2. Niniejsza wiadomosc stanowi jedynie wyraz prywatnych pogladow autora
i nie jest w zadnym wypadku zwiazana ze stanowiskiem przedsiebiorstwa
Wirtualna Polska S.A.
------------------------------------------------------------------------
WIRTUALNA POLSKA SA, ul. Traugutta 115c, 80-226 Gdansk; NIP: 957-07-51-216;
Sad Rejonowy Gdansk-Polnoc KRS 0000068548, kapital zakladowy 62.880.024 zlotych (w calosci wplacony)
--
http://www.freelists.org/webpage/oracle-l
|
|
