>No, by default this package will be created under the user who
>compiles it (the schema owner). Janet what are you thoughts on the
>variable type? I haven't been able to return a ref cursour when its
>specified as just OUT.
Adam -
You are correct. The package is owned by the user who creates it and they
are the only ones who can execute a procedure in the package until they
'grant execute on the package' to the user executing it or to a role
granted to the user or to public (which most DBA's will frown upon).
I also think the variable type needs to be of type IN OUT as mentioned
previously.
Janet.
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
