Link to home
Start Free TrialLog in
Avatar of bkreynolds48

asked on

ora 904 invalid identifier 10g

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
Avatar of slightwv (䄆 Netminder)
slightwv (䄆 Netminder)

It looks like the function on the one server isn't correct/working.
Avatar of bkreynolds48


I tried taking the function that works and putting it in the other database but still have the same error
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
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.
will give that a try tomorrow - thanks
Avatar of Guy Hengel [angelIII / a3]
Guy Hengel [angelIII / a3]
Flag of Luxembourg image

Link to home
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
the permissions were granted through a role and work fine elsewhere - this is a new build so something was missed