soci/docs/procedures.md

0001 # Stored Procedures
0002
0003 The `procedure` class provides a convenient mechanism for calling stored procedures:
0004
0005 ```cpp
0006 sql << "create or replace procedure echo(output out varchar2,"
0007         "input in varchar2) as "
0008         "begin output := input; end;";
0009
0010 std::string in("my message");
0011 std::string out;
0012 procedure proc = (sql.prepare << "echo(:output, :input)", use(out, "output"), use(in, "input"));
0013 proc.execute(true);
0014 assert(out == "my message");
0015 ```
0016
0017 ## Portability note
0018
0019 The above way of calling stored procedures is provided for portability of the code that might need it.
0020 It is of course still possible to call procedures or functions using the syntax supported by the given database server.