APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Error calling remote procedure

DirdMay 24 2010 — edited May 24 2010

Hi guys,

Can anyone help with the following PL/SQL; I've been trying different things but get an error each time:

DECLARE
TimeBasedNr NUMBER(18);
UserId     VARCHAR2(8);
ReturnCode VARCHAR2(1) := NULL;
BEGIN 
TimeBasedNr := 200908260228739400;
UserId := 'D134ATE';
iaadmin.iap00002_001_1.UpdateSingle001@db_link(TimeBasedNr, UserId, ReturnCode);
END;

I get "Error at line 8: PL/SQL: Statement ignored" for the procedure call. It works fine locally on the database (without the database link). Thanks for help.

Mike

This post has been answered by 646538 on May 24 2010

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Jun 21 2010

Added on May 24 2010

#apex, #apex-discussions

14 comments

2,033 views