Inout
parameters
BigQuery
Db2 (LUW)
MariaDB
MySQL
Oracle DB
PostgreSQL
SQL Server
SQLite
2005
2007
2009
2011
2013
2015
2017
2019
2021
⚠ 2017 - 2022
b
✓ 14+
⚠ 18c - 21c
c
⊘ 11gR1 - 12cR2
✓ 5.0+
✓ 10.3+
⊘ 5.1 - 10.2
✓ 11.1+
⊘ 2.0
Not supported by the latest JDBC driver, which I use for testing
Proprietary syntax:
<varname> <type name> output
(output has
inout
semantics)
Proprietary syntax:
<varname> in|out|in out <type name>