FUNCTION_TYPE = BIND DEFINE AUTHORIZE STATEMENT TRANSACTION

set ORA_OCI_UCBPKG=ocispy8i
sqlplus

OCISPY (Version 0.2) Copyright (c) 2001 by Sergey Sikorskiy.
Copy policy: FREE FOR COMMERCIAL AND NON-COMMERCIAL USE.
Download last release: http://www.oocities.org/ocispy/

Environment handle configuration:
mode =
OCI_ATTR_HEAPALLOC = 1420
OCI_ATTR_CACHE_MAX_SIZE = 10
OCI_ATTR_CACHE_OPT_SIZE = 8388608

OCISessionBegin
OCIStmtPrepare stmt:
[SELECT NULL FROM DUAL FOR UPDATE NOWAIT]

OCIStmtExecute iters: 0, mode: OCI_DEFAULT
OCIStmtFetch nrows: 1, mode: OCI_DEFAULT
OCIStmtPrepare stmt:
[BEGIN DBMS_OUTPUT.DISABLE; END;]

OCIStmtExecute iters: 1, mode: OCI_DEFAULT
OCIStmtPrepare stmt:
[BEGIN DBMS_APPLICATION_INFO.SET_MODULE(:1,NULL); END;]

OCIBindByPos pos: 1 val: 'SQL*Plus' type: SQLT_CHR mode: OCI_DEFAULT
OCIStmtExecute iters: 1, mode: OCI_DEFAULT
OCIStmtPrepare stmt:
[SELECT DECODE('A','A','1','2') FROM DUAL]

OCIDefineByPos pos: 1 type: SQLT_NUM mode: OCI_DEFAULT
OCIStmtExecute iters: 1, mode: OCI_DEFAULT
OCIStmtPrepare stmt:
[select * from dual]

OCIStmtGetBindInfo
OCIStmtExecute iters: 0, mode: OCI_DEFAULT
OCIDefineByPos pos: 1 type: SQLT_STR mode: OCI_DEFAULT
OCIStmtFetch nrows: 15, mode: OCI_DEFAULT
OCISessionEnd