Re: Error on calling SQL Stored procedure

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