×
The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.
All,
Someone on the list pointed me in the right direction with a question he asked.
So... I included a question mark where the expected return parameter should be in the call, in the example PGMLIB.OEXX55S('Parm1','Parm2',?,?,?) for 3 returned parameters...and Eureka it worked. It returns the parameter names and values in the message area.
Thanks!
Ken
----- Original Message -----
From: "Ken Meade" <kmeade@xxxxxxxxxxxxxxxxx>
To: "Midrange Systems Technical Discussion" <midrange-l@xxxxxxxxxxxxxxxxxx>
Sent: Wednesday, May 26, 2021 3:52:21 PM
Subject: [ EXTERNAL ] Calling stored procedure from ACS RUN SQL with return parameters
I'm trying to test a stored procedure that is returning parameters and I thought in the past I could do this in the ACS RunSQL tool.
If I call a stored procedure that doesn't return a parameter, the call appears to work. But when I do the same with one that is expecting returned parameters I get the error message: [SQL0440] Routine OEXX55S in PGMLIB not found with specified parameters. However I've confirmed the object exists and has the correct inbound parameters. I've also validated my authorization associated with the object. I'm just doing a simple call PGMLIB.OEXX55S('Parm1','Parm2');
Thanks,
Ken
Ken Meade | Director of Information Technology
[ mailto:kmeade@xxxxxxxxxxxxxxxxx | kmeade@xxxxxxxxxxxxxxxxx ] | (603) 444-3570
Littleton Coin Company, Inc.
1309 Mt Eustis Rd, Littleton NH 03561
[
http://www.littletoncoin.com/ | www.littletoncoin.com ]
midrange.com
