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

["Jim Womeldorf" <jwomeldo@fastenal.com>]

I Think this will work:

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

BEGIN-SELECT
processSP($deptID) &NUM
        LET #NUM = &NUM
FROM DUAL
END-SELECT

Jim

-----Original Message-----
From: sqr-users-bounces+jwomeldo=fastenal.com@sqrug.org
[mailto:sqr-users-bounces+jwomeldo=fastenal.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