Re: [ EXTERNAL ] Calling stored procedure from ACS RUN SQL with return parameters

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 ]