ORA 6503 - function argument across a database link:

From: <dbaplusplus_at_hotmail.com>
Date: 18 Dec 2005 07:04:35 -0800
Message-ID: <1134918275.536160.77100@g47g2000cwa.googlegroups.com>

I am using .Oracle 10.1..0.4 on HP UNIX 11i

When I run following sql it runs fine:
select ord_cntrl_no, sum(tp_load.exp_wght(load.rowid)) from load where ord_cntrl_no = 40804346
group by ord_cntrl_no;
exit;

But when I run same statement where load table is across in a db link, I get ORA-6503 error, why?
select ord_cntrl_no, sum(tp_load.exp_wght(load.rowid)) from load_at_linktofdc where ord_cntrl_no = 40804346 group by ord_cntrl_no;
exit;

I get

select ord_cntrl_no, sum(tp_load.exp_wght(load.rowid))

                         *

ERROR at line 1:
ORA-06553: PLS-306: wrong number or types of arguments in call to 'EXP_WGHT' Am I doing anything wrong? Received on Sun Dec 18 2005 - 09:04:35 CST