I have two database links going from one database to two others.
I do a
select owner.function_name@database_link ('50458093010') from dual;
one works the other doesn't
other than the owner and the database link everything is the same including the function
have no clue as to why
the database links test successfully
Oracle Database
Last Comment
bkreynolds48
8/22/2022 - Mon
slightwv (䄆 Netminder)
It looks like the function on the one server isn't correct/working.
bkreynolds48
ASKER
I tried taking the function that works and putting it in the other database but still have the same error
slightwv (䄆 Netminder)
Log into the other database and make sure the function works.
Double check the database link is using the correct user and thus executing the correct function.
Are the database versions between the working server and non-working server the same?
it runs fine in the destination server but when it is run in database one with the database link it doesn't work - link is fine - very weird - database version / os are the same - will go and check the user in the link
slightwv (䄆 Netminder)
As a sanity check, on the failed server add a dbms_output.put_line('Hello World'); to the function. Then "set serveroutput on" on the calling session and call the function.
You should see the output to make sure you are calling the correct function.