[Date Prev][Date Next][Thread Prev][Thread Next]
[Author Index]
[Date Index]
[Thread Index]
[SQR-USERS Info]
[SQRUG Home Page]
RE: [sqr-users] Calling Oracle Stored Procedure from SQR thruProcessScheduler
- Subject: RE: [sqr-users] Calling Oracle Stored Procedure from SQR thruProcessScheduler
- From: "George Jansen" <GJANSEN@aflcio.org>
- Date: Wed, 03 May 2006 17:13:40 -0400
- Delivery-date: Wed, 03 May 2006 17:16:36 -0400
- List-id: "This list is for discussion about the SQR database reportinglanguage from Hyperion Solutions." <sqr-users.sqrug.org>
The SQR syntax appears to be OK if this is making it through to the PL/SQL
parser and you're getting a PLS error. Is it possible that the Process
Scheduler is running under a different login and you need to qualify processSP
with its owner, e.g
#NUM = FOO.processSP($dept_id);;
_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users