RE: [sqr-users] Calling Oracle Stored Procedure from SQR thruProcessScheduler

[<KSchaetzly@eprod.com>]

The BEGIN and END should not start in column1. Indent within BEGIN-SQL
and END-SQL like:

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

-----Original Message-----
From: sqr-users-bounces+kschaetzly=eprod.com@sqrug.org
[mailto:sqr-users-bounces+kschaetzly=eprod.com@sqrug.org] On Behalf Of
Vedagiri, Balaji (GE, Corporate, consultant)
Sent: Wednesday, May 03, 2006 3:47 PM
To: sqr-users@sqrug.org
Subject: [sqr-users] Calling Oracle Stored Procedure from SQR thru
ProcessScheduler

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

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