How can I make it possible to return only the first parameter from a stored procedure with multiple OUT-parameters? Overview of Parameters Position Parameter Type 1 OUT 2 OUT So instead of create the CALL statement like this CALL SCHEMA.PROC123(?, ?); I try to do this CALL SCHEMA.PROC123(?);

Reputation: 1

Return only the first parameter from stored procedure

How can I make it possible to return only the first parameter from a stored procedure with multiple OUT-parameters?

Overview of Parameters

Position	Parameter Type
1	OUT
2	OUT

So instead of create the CALL statement like this

CALL SCHEMA.PROC123(?, ?);

I try to do this

CALL SCHEMA.PROC123(?);

Upvotes: 0

Answers (1)

Florian Pfeffer

Reputation: 269

OUT parameters in SQLScript are not optional. At the moment the only way to reach want you want to have, is, to create a wrapper procedure with only the one required OUT parameter.

Upvotes: 1

Return only the first parameter from stored procedure

Answers (1)

Related Questions