CREATE USER via PL/SQL
From: Frank Greene <74200.427_at_CompuServe.COM>
Date: 4 Jan 1995 00:44:34 GMT
Message-ID: <3ecr1i$65j$1_at_mhade.production.compuserve.com>
Date: 4 Jan 1995 00:44:34 GMT
Message-ID: <3ecr1i$65j$1_at_mhade.production.compuserve.com>
We are developing a new system using powerbuilder as a front end into V7. Is there any method whereby we can issue a CREATE / ALTER / DELETE user command from within PL/SQL Procedures. That is
BEGIN CREATE USER user1 IDENTIFIED BY password1; END;
This obviously gives a compilation error as shown.
I also tried to start a sql script from within a procedure but this also causes an error. So does trying to start a sql script direct from the operating system via the HOST variable.
We need to use procedures to link powerbuilder to oracle, so the answer to this is quite importantant to our development effort.
Suggestions as to how to work around this limitation??? Received on Wed Jan 04 1995 - 01:44:34 CET