Re: Rowtype operator in a stored procedure

Dear Sir:

Seems to me you can not, because PL/SQL use information about %ROWTYPE from data dictionary where, in your case, it does not exist. Try to use view:

create view table_view is select table_col1,... from table__at_link_;

I doubt, but it could help.

If you inform me about result, I would appreciate that (I currently don't work in distributed environment).

Best wishes:

Eugene.

Ed Jennings wrote:
>
> I am writing a stored procedure that defines a variable of type
> XXX%ROWTYPE, where XXX is in another schema, referenced via a
> synonym. All of the appropriate permissions are in place, however
> I am receiving a PLS-201 (XXX must be declared) error message.
> If I compile this same stored procedure under the XXX userid, it
> works just fine. My question is this: Can I use ROWTYPE to reference
> an object in another schema? If so, what do I need to do to provide
> the necessary visibility?
>
> Any guidance will be appreciated.
> --
> ~~~~~~~~~~~~~~~~~~~~~~~~~
> jennings_at_dca.net
Received on Thu Jul 11 1996 - 00:00:00 CEST