Unable to call remote procedure

Hi there ! I have a problem...

I am trying to call a remote stored procedure thru a Database Link in SQLPlus. Something like:

exec DBMS_SPACE.UNUSED_SPACE_at_LinkName (

:segment_owner, :segment_name,
:segment_type, :total_blocks, :total_bytes, :unused_blocks,
:unused_bytes, :last_used_extent_file_id ,
:last_used_extent_block_id,
:last_used_block );

Error returned is:

BEGIN
*
ERROR at line 1:
ORA-02068: following severe error from <LinkName> ORA-06512: at line 2

oerr returns:

02068, 00000, "following severe error from %s%s"

// *Cause: A severe error (disconnect, fatal Oracle error) received from
//         the indicated database link.  See following error text.
// *Action: Contact the remote system administrator.

The same function call works fine on the local machine i.e without the @LinkName indicating that parameters are being passed okay. Also
DBMS_OUTPUT.PUT_LINE_at_LinkName( 'Hello World'); returns:
PL/SQL procedure successfully completed. which means the link is working fine.

I am completely stumped. Any help would be appreciated.

Thanks

Roy Varghese

E-Mail: rvarghese_at_ibm.net Received on Thu Dec 04 1997 - 00:00:00 CST