Try to add a blank after the comma(s).
In some environments the comma (if there is something before and after it) is interpreted as decimal point.
Mit freundlichen Grüßen / Best regards
Birgitta Hauser
"Shoot for the moon, even if you miss, you'll land among the stars." (Les Brown)
"If you think education is expensive, try ignorance." (Derek Bok)
"What is worse than training your staff and losing them? Not training them and keeping them!"
„Train people well enough so they can leave, treat them well enough so they don't want to.“ (Richard Branson)
-----Original Message-----
From: MIDRANGE-L <midrange-l-bounces@xxxxxxxxxxxxxxxxxx> On Behalf Of Pete Helgren
Sent: Freitag, 21. Mai 2021 04:02
To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxxxxxxxx>
Subject: 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
midrange.com
