Re: ORA 6503 - function argument across a database link:

This is a long shot as I ran across a similar problem many years ago (I think) that was simply fixed by adding the @linktofdc to the function. Where does the function reside and who owns it?

Like this maybe

select ord_cntrl_no, sum(tp_load.exp_wght_at_linktofdc(load.rowid)) from load_at_linktofdc where ord_cntrl_no = 40804346 group by ord_cntrl_no;

dbaplusplus_at_hotmail.com wrote:
> 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 - 23:52:50 CST