Out sysdate parameter kills the connection.

OciPort = erloci:new([{logging, true}, {env, [{"NLS_LANG", "GERMAN_SWITZERLAND.AL32UTF8"}]}]).
OciSession = -------     Connection to database   --------.
SelectSysdate = <<"BEGIN :SQLT_DAT_OUT_RESULT := TO_DATE(SYSDATE); END;">>,
BoundStmt = OciSession:prep_sql(SelectSysdate).
SelectBinds = [{<<":SQLT_DAT_OUT_RESULT">>, out, 'SQLT_DAT'}].
ok = BoundStmt:bind_vars(SelectBinds).
f(R1).
R1 = [{<<0,0,0,0,0,0,0,0>>}].
BoundStmt:exec_stmt(R1).

Results in:

06.09.2016 08:59:32.721699 [error] [_OCI_] {c_src/erloci_lib/ocistmt.cpp,execute,780} Unsuported out variable type 12 (BEGIN :SQLT_DAT_OUT_RESULT := TO_DATE(SYSDATE); END;)
{error,{0,<<"[execute:779] unsupporetd type 12\n">>}}
{oci_logger,103} TCP closed
(sbsgui@127.0.0.1)27> {oci_logger,132} Terminating normal

K2InformaticsGmbH / erloci

Out sysdate parameter kills the connection. #26