Re: Use of ORACLE PL/SQL procedure with link in SQR

[Atholl Reid <Atholl.Reid@ANU.EDU.AU>]

Hello all

At 16:01 10/11/2000 -0800, Emma Vavra <evavra@LELAND.STANFORD.EDU> wrote:
>>>>
> I am trying to call an ORACLE PL/SQL  procedure  from a package in the SQL paragraph in SQR program.
> The package  is defined in the local database but contains a call to a procedure in a different database via a link
> The link is defined as a public link.  The PL/SQL  block that I am using in the SQR works perfectly well if I execute it in SQL Plus, but
> does not seem to work from the SQR.
> Has anybody tried to do this? Is it working for you? Can anybody point me to any documentation?
>
> This is the error . The error appears at the point that the local procedure actually calls the remote procedure via a link.
<<<<

Just a quick thought: it might be worth looking at the access that you have from the SQR if you have not already done so.  Hope that this suggestion doesn't insult you.

Squidely pop

Atholl


Atholl Reid                              'phone : 61 2 6249 0516
Enterprise Solution Project (ESP)        fax    : 61 2 6249 5960
K Block, Building 3 (Old Amin. Area)     email  : Atholl.Reid@anu.edu.au
The Australian National University             www    : http://esp.anu.edu.au/
CANBERRA ACT 0200

Please Note: from January 1 2001, please replace 6249 with 6125 in the above 'phone numbers.


You can't have everything, where would you put it?