Re: Error on calling SQL Stored procedure

[x y <xy6581@xxxxxxxxx>]

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:

> Routine MYROUTINE in MYDEMO not found with specified parameters is the
> error.
>
> CREATE OR REPLACE PROCEDURE mydemo.myroutine(
>                  IN  Code VARCHAR(10),
>                  IN  APIKEY    VARCHAR(50),
>                  OUT  txtout VARCHAR(50),
>                  OUT curValue FLOAT,
>                  OUT conditions VARCHAR(50)
>              )
>          LANGUAGE sql
>          RESULT SETS 0
>
> .............(procedure code here)
>
>
> Call it this way:
>
> CALL MYDEMO/MYROUTINE ('78888', '91737ac3b9db0bgfd4325c2675e02126')
>
> I have tried this:  CALL MYDEMO/MYROUTINE ('78888',
> '91737ac3b9db0bgfd4325c2675e02126', ?,?,?)  but that returns  "Use of
> parameter marker or NULL not valid."
>
> I don't spend much time in SQL-land so I am probably missing something
> simple.  I assume it is complaining about the call parameters or the way
> it is called.  But could there be other causes?
>
> --
> 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
>
> --
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: https://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at https://archive.midrange.com/midrange-l.
>
> Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription related
> questions.
>
> Help support midrange.com by shopping at amazon.com with our affiliate
> link: https://amazon.midrange.com