<martin.dsouza_at_gmail.com> wrote in message
news:1104248456.830589.267110_at_z14g2000cwz.googlegroups.com...
> Hi,
>
> I'm trying to reference a package from another schema in a trigger...
>
> The trigger code is:
>
> BEGIN
> SELECT <seq_name>.nextval
> INTO other_schema.global_package.identity -- Where identity is a
> global variable
> FROM dual;
> :new.TEXTID:=other_schema.global_package.identity;
> END;
>
> I get the following error message:
>
> Error Text = PLS-00201: identifier 'other_schema.global_package' must
> be declared.
>
> The package that I created works fine. Any ideas? thanks
>
>
privs acquired from ROLEs do NOT exist within PL/SQL procedures that execute
with definer rights.
Received on Tue Dec 28 2004 - 11:42:42 CST
