I dont't know much of oraperl, but it seems like there are two sources
of this error:
- In general, executing DDLs like DROP TABLE might cause unpredictable
behaviour on any open cursors. So be sure to close the transaction by
COMMITing explicitly before executing DDLs.
- Dropping/creating uses in particurlar might not succeed if there are
open transactions on the affected user. Also the object privileges to be
granted to the newly created user on the existing user's objects might
involve re-connecting to the latter one, as the privileging scheme does
not allow a user to GRANT another user's object privileges, so one must
use insecure techniques like public passwords or highly system
privileged accounts. Thus I would avoid creating users on a regular base
in the course of operation. Isn't it possible just to drop/re-create the
new user's objects?
Marcus Reichardt
Consultant
Received on Wed Jul 01 1998 - 06:52:37 CDT