Oracle Database Discussions

We are attempting to execute an AS400 stored procedure via the gateway (v11.1.0.6). The stored procedure works just fine on the 400.

The script is:

SQL> DECLARE

2 CMPNYNO DECIMAL(2,0);

3 ACCT DECIMAL(8,0);

4 PROD DECIMAL(4,0);

5 DISCDATE DECIMAL(8,0);

6 DISCAMTD DECIMAL(9,2);

7 DISCAMT DECIMAL(9,2);

8 RTNCDTN DECIMAL(3,0);

9 BEGIN

10 CMPNYNO := 1;

11 ACCT := 12873816;

12 PROD := 3;

13 DISCDATE := 20101001;

14 PGMLIB.RS7235P@itcd_dqa(CMPNYNO, ACCT, PROD, DISCDATE, DISCAMTD, DISCAMT, RTNCDTN);

15 END;



The error returned is:

ERROR at line 14:

ORA-06550: line 14, column 1:

PLS-00201: identifier 'PGMLIB.RS7235P@ITCD_DQA' must be declared

ORA-06550: line 14, column 1:

PL/SQL: Statement ignored


I have granted execute authority to the user profile associated to the gateway.

We execute "normal" queries to tables on the 400 without problem. This is the first time we've tried accessing a stored procedure, so this is new territory.

Advice?