Calling DB2 stored procedure with output parameter

[Hung Tam Nguyen]

For a DB2 stored procedure defined as.

CREATE OR REPLACE PROCEDURE A.SP

(

IN  in_variable SMALLINT,

OUT out_variable VARCHAR(9)

)

BEGIN

    CALL A.ANOTHER_SP(in_variable, out_variable);

END

We can run it easily directly on the database server via command line or using other SQL tools like this:

call A.SP(42, ?)

But in DBSolo it doesn't work, the error is:

       [jcc][10143][10845][3.64.114] Invalid parameter 1: Parameter is not set nor registered. ERRORCODE=-4461, SQLSTATE=42815

How can we make DBSolo understand the ? character in SQL editor?     

[DB Solo Admin]

Hi,

Something like this should work

begin
  DECLARE outParam VARCHAR(9);
  CALL A.SP(5, outParam);
end


marko

[Hung Tam Nguyen]

yes that works using CTRL+SPACE to execute, but why doesn't it accept the standard one-liner call command?  

Is there any way to maybe escape the ? character in DBsolo and make it work? our devs won't like the idea of having to check the procedure code all the time just redeclare output variables before execution.

[DB Solo Admin]

Currently there is no way to make it work except the method I posted earlier. I can investigate if support for this could be added somehow.

marko

[Hung Tam Nguyen]

Thank you, that would be great! Please write back once you have done investigating.

--
You received this message because you are subscribed to a topic in the Google Groups "DB Solo" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/db-solo/4oWckC92F1M/unsubscribe.
To unsubscribe from this group and all its topics, send an email to db-solo+unsubscribe@googlegroups.com.
To post to this group, send email to db-...@googlegroups.com.
Visit this group at https://groups.google.com/group/db-solo.
For more options, visit https://groups.google.com/d/optout.