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
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

indx NUMBER;

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

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


a_table remote_package.my_table_tab@REMOTE_HOST

a_table := my_function@REMOTE_HOST;

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


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

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!

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.