Re^2: How to access MySQL stored procedures OUT parameter(s)

kcott:

I've not tried it with MySQL, but I'm pretty sure (95%) that I used bind_param_inout a good few times with the Oracle and MSSQL drivers.

...roboticus

When your only tool is a hammer, all problems look like your thumb.

Comment on Re^2: How to access MySQL stored procedures OUT parameter(s)

Replies are listed 'Best First'.
Re^3: How to access MySQL stored procedures OUT parameter(s) by kcott (Archbishop) on Sep 01, 2017 at 04:10 UTC
I said "It's been years"; on reflection, it's probably been over a decade. However, from subsequent replies, it looks like `bind_param_inout` was indeed the method I used. Like you, I've not used it with MySQL: I've never written a MySQL stored procedure nor had to write any DBI code to interface with one (although, I have used DBD::mysql many times over the years with plain SQL). I've definitely used it with Oracle; pretty sure I've also used it with one or both of Postgres and Informix; and, I think Sybase as well (although I'm less certain about that one). — Ken	[reply] [d/l]

Replies are listed 'Best First'.

Re^3: How to access MySQL stored procedures OUT parameter(s)
by kcott (Archbishop) on Sep 01, 2017 at 04:10 UTC

I said "It's been years"; on reflection, it's probably been over a decade. However, from subsequent replies, it looks like bind_param_inout was indeed the method I used.

Like you, I've not used it with MySQL: I've never written a MySQL stored procedure nor had to write any DBI code to interface with one (although, I have used DBD::mysql many times over the years with plain SQL).

I've definitely used it with Oracle; pretty sure I've also used it with one or both of Postgres and Informix; and, I think Sybase as well (although I'm less certain about that one).

— Ken

[reply]
[d/l]