Rowtype operator in a stored procedure
From: Ed Jennings <jennings_at_dca.net>
Date: 1996/07/11
Message-ID: <31E56C86.7273_at_dca.net>#1/1
Date: 1996/07/11
Message-ID: <31E56C86.7273_at_dca.net>#1/1
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