[sqr-users] Calling Oracle Stored Procedure from SQR thru ProcessScheduler

["Vedagiri, Balaji \(GE, Corporate, consultant\)" <balaji.vedagiri@ge.com>]

Hi

I am trying to call an Oracle SP from the SQR. Its working fine when I execute 
the same through command prompt,
but the following error is shown when I execute through the process scheduler. 
Can anyone help me on this,

Code:

BEGIN-PROCEDURE CALL-ORACLE-SP
LET $spErr = 'N'

BEGIN-SQL
BEGIN 
#NUM := processSP($deptID);; 
END;; 
END-SQL 

DO CHECK-SP-PROGRESS

Error:

(SQR 5528) ORACLE OCIStmtExecute error 6550 in cursor 27:
   ORA-06550: line 1, column 14:
PLS-00201: identifier 'processSP' must be declared
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored

Error on line 523:
   (SQR 3735) Could not execute SQL.

SQR for PeopleSoft: Program Aborting.

This SP is available in the Oracle Instance and I checked in the back-end,
Do I need to give the SP name in any DECLARE statement, please advice.

Thanks in Advance
Balaji



_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users