Panic when calling procedure

[arthrarnld]

When trying to execute

CALL proc.myProc(?);

we get an invalid memory address or nil pointer dereference error.

This seems to be related to the use of the question mark, so maybe the driver is interpreting it as a placeholder in a prepared statement? If so, is it possible to escape it?

[stfnmllr]

Yes, the ? is interpreted as place-holder for an in, in-out or out variable of the stored procedure. For what does the ? stand in your example? Can you please share the definition of the stored procedure and the go code calling it?

[arthrarnld]

@d024441, according to the HANA Help Page:

The actual value passed for tabular OUT parameters must be?.

and

When you pass '?' to the output parameters, temporary tables holding the result sets will be generated. These tables will be dropped automatically once the database session is closed.

Without the question mark, how else could I invoke a procedure to simply get its result (as opposed to calling from within another procedure where the result could be stored in a local variable)?

Thanks!

[stfnmllr]

Hi @arthurpaimarnold,

Without the question mark, how else could I invoke a procedure to simply get its result (as opposed to calling from within another procedure where the result could be stored in a local variable)?

Yes, sure. Please check the example code - maybe this will help:
call stored procedure with out parameter
call stored procedure with table result

If not - to reproduce the issue, we need

• the definition (header) of the stored procedure and
• the go code 'calling' the stored procedure

[arthrarnld]

@d024441 the examples you provided solved the issue. Thank you very much!