469,658 Members | 1,844 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,658 developers. It's quick & easy.

Remote Function Call: Internal Error

I am writing stored proecdures on Oracle 9 (release 1 I believe). I am
having difficulty creating a stored procedure that makes a remote
function call to a database on a different host.

On the remote database I declare the following package:

----------

create or replace package remote_package
as
cursor cursor_a is select * from my_table;
type my_table_tab is table of cursor_a%ROWTYPE;

----------

I declare the following function

---------
create or replace function my_function return
remote_package.my_table_tab

as
indx NUMBER;

BEGIN
open remote_package.cursor_a;
indx := 0;
for rec_a in remote_package.cursor_a
loop
my_table_tab(indx) := rec_a;
indx := indx + 1;
end loop;

END;
-----------------
On my local database, I have the following procedure written:
-------------------------
create or replace procedure call_remote

as

a_table remote_package.my_table_tab@REMOTE_HOST

begin
a_table := my_function@REMOTE_HOST;
end;
--------------------------------

When I run the local SQL statement to create the procedure, I get the
following error:

PLS-00801: INTERNAL ERROR[1401]

I made sure that:
@REMOTE_HOST is valid
When I deploy the package and functions locally, everything works
perfectly.

For some reason calling the package and function that is passing back
a table of records is just not working and I am not sure why. Any
help would be greatly appreciated, thanks!

-PK
Jul 19 '05 #1
0 4329

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

9 posts views Thread by Penn Markham | last post: by
reply views Thread by Job Kelderman | last post: by
12 posts views Thread by Bryan Parkoff | last post: by
reply views Thread by Kid A | last post: by
reply views Thread by gheharukoh7 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.