Re: Error on calling SQL Stored procedure - SOLVED

[Pete Helgren <pete@xxxxxxxxxx>]

Thanks!  To you and Birgitta.  I was creating the Proc in Run SQL 
Scripts but testing it in STRSQL, so fix #1 was run it in ACS. Fix #2 
was adding blanks at the end for the "OUT" parameters:

Final solution: CALL MYDEMO/MYROUTINE ('78888', 
'91737ac3b9db0bgfd4325c2675e02126','','','')

STRSQL returns: "IN, OUT, or INOUT not valid for parameter 3 in 
procedure" when run with the three blanks....never thought of running it 
in ACS..  Solved!

Pete Helgren
www.petesworkshop.com
GIAC Secure Software Programmer-Java
AWS Certified Cloud Practitioner
Microsoft Certified: Azure Fundamentals
Twitter - Sys_i_Geek  IBM_i_Geek

On 5/21/2021 12:39 AM, x y wrote:
> I can't recall ever getting this model to work with STRSQL...but runs fine
> under Run SQL Scripts through ACS or RDi.
>
> On Thu, May 20, 2021 at 7:02 PM Pete Helgren<pete@xxxxxxxxxx>  wrote: