Navigation Menu

Skip to content

Instantly share code, notes, and snippets.

@theory

theory/COLLECT issue ora_trace 6

Last active December 17, 2015 02:09
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save theory/5533696 to your computer and use it in GitHub Desktop.
Save theory/5533696 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
COLLECT issue ora_trace 6
dbd_preparse scanned 1 distinct placeholders
OCIHandleAlloc(7f9c69160200,7f9c698246d8,OCI_HTYPE_STMT,0,0)=SUCCESS
OCIStmtPrepare(7f9c69195010,7f9c69183df0,'
SELECT c.change_id
, COLLECT(t.tag) AS tags
FROM changes c
LEFT JOIN tags t ON c.change_id = t.change_id
WHERE c.project = :p1
GROUP BY c.change_id
',207,1,0)=SUCCESS
OCIAttrGet(7f9c69195010,OCI_HTYPE_STMT,7f9c698246ec,0,OCI_ATTR_STMT_TYPE,7f9c69183df0)=SUCCESS
dbd_st_prepare'd sql SELECT ( auto_lob1, check_sql1)
dbd_describe SELECT (EXPLICIT, lb 80)...
OCIStmtExecute(7f9c69173588,7f9c69195010,7f9c69183df0,0,0,0,0,mode=DESCRIBE_ONLY,16)=SUCCESS
OCIAttrGet(7f9c69195010,OCI_HTYPE_STMT,7fff5dc79724,0,OCI_ATTR_PARAM_COUNT,7f9c69183df0)=SUCCESS
OCIParamGet(7f9c69195010,4,7f9c69183df0,7f9c69824dc0,1,OCI_HTYPE_STMT)=SUCCESS
OCIAttrGet(7f9c69194b60,OCI_DTYPE_PARAM,7f9c69824df0,0,OCI_ATTR_DATA_TYPE,7f9c69183df0)=SUCCESS
OCIAttrGet(7f9c69194b60,OCI_DTYPE_PARAM,7f9c69824df2,0,OCI_ATTR_DATA_SIZE,7f9c69183df0)=SUCCESS
OCIAttrGet(7f9c69194b60,OCI_DTYPE_PARAM,7f9c69824e08,0,OCI_ATTR_CHAR_USED,7f9c69183df0)=SUCCESS
OCIAttrGet(7f9c69194b60,OCI_DTYPE_PARAM,7f9c69824e0a,0,OCI_ATTR_CHAR_SIZE,7f9c69183df0)=SUCCESS
OCIAttrGet(7f9c69194b60,OCI_DTYPE_PARAM,7f9c69824e0c,0,OCI_ATTR_CHARSET_ID,7f9c69183df0)=SUCCESS
OCIAttrGet(7f9c69194b60,OCI_DTYPE_PARAM,7f9c69824e0e,0,OCI_ATTR_CHARSET_FORM,7f9c69183df0)=SUCCESS
OCIAttrGet(7f9c69194b60,OCI_DTYPE_PARAM,7f9c69824df4,0,OCI_ATTR_PRECISION,7f9c69183df0)=SUCCESS
OCIAttrGet(7f9c69194b60,OCI_DTYPE_PARAM,7f9c69824df6,0,OCI_ATTR_SCALE,7f9c69183df0)=SUCCESS
OCIAttrGet(7f9c69194b60,OCI_DTYPE_PARAM,7f9c69824df7,0,OCI_ATTR_IS_NULL,7f9c69183df0)=SUCCESS
OCIAttrGet(7f9c69194b60,OCI_DTYPE_PARAM,7f9c69824df8,7fff5dc79720,OCI_ATTR_NAME,7f9c69183df0)=SUCCESS
Describe col #1 type=96(CHAR)
Described col 1: dbtype 96(CHAR), scale 0, prec 40, nullok 0, name CHANGE_ID
: dbsize 40, char_used 0, char_size 40, csid 873, csform 1(SQLCS_IMPLICIT), disize 40
fbh 1: 'CHANGE_ID' NO null , otype 96-> 5, dbsize 40/41, p40.s0
OCIParamGet(7f9c69195010,4,7f9c69183df0,7f9c69824e68,2,OCI_HTYPE_STMT)=SUCCESS
OCIAttrGet(7f9c69194b10,OCI_DTYPE_PARAM,7f9c69824e98,0,OCI_ATTR_DATA_TYPE,7f9c69183df0)=SUCCESS
OCIAttrGet(7f9c69194b10,OCI_DTYPE_PARAM,7f9c69824e9a,0,OCI_ATTR_DATA_SIZE,7f9c69183df0)=SUCCESS
OCIAttrGet(7f9c69194b10,OCI_DTYPE_PARAM,7f9c69824eb0,0,OCI_ATTR_CHAR_USED,7f9c69183df0)=SUCCESS
OCIAttrGet(7f9c69194b10,OCI_DTYPE_PARAM,7f9c69824eb2,0,OCI_ATTR_CHAR_SIZE,7f9c69183df0)=SUCCESS
OCIAttrGet(7f9c69194b10,OCI_DTYPE_PARAM,7f9c69824eb4,0,OCI_ATTR_CHARSET_ID,7f9c69183df0)=SUCCESS
OCIAttrGet(7f9c69194b10,OCI_DTYPE_PARAM,7f9c69824eb6,0,OCI_ATTR_CHARSET_FORM,7f9c69183df0)=SUCCESS
OCIAttrGet(7f9c69194b10,OCI_DTYPE_PARAM,7f9c69824e9c,0,OCI_ATTR_PRECISION,7f9c69183df0)=SUCCESS
OCIAttrGet(7f9c69194b10,OCI_DTYPE_PARAM,7f9c69824e9e,0,OCI_ATTR_SCALE,7f9c69183df0)=SUCCESS
OCIAttrGet(7f9c69194b10,OCI_DTYPE_PARAM,7f9c69824e9f,0,OCI_ATTR_IS_NULL,7f9c69183df0)=SUCCESS
OCIAttrGet(7f9c69194b10,OCI_DTYPE_PARAM,7f9c69824ea0,7fff5dc79720,OCI_ATTR_NAME,7f9c69183df0)=SUCCESS
Describe col #2 type=108(ORA_XMLTYPE or SQLT_NTY)
OCIHandleAlloc(7f9c69160200,7f9c698246e0,OCI_HTYPE_DESCRIBE,0,0)=SUCCESS
Described col 2: dbtype 108(ORA_XMLTYPE or SQLT_NTY), scale 0, prec 0, nullok 1, name TAGS
: dbsize 2000, char_used 0, char_size 0, csid 0, csform 0(0), disize 0
fbh 2: 'TAGS' NULLable, otype 108->108, dbsize 2000/0, p0.s0
OCIAttrSet(7f9c69195010,OCI_HTYPE_STMT, 7fff5dc7972c,4,Attr=OCI_ATTR_PREFETCH_MEMORY,7f9c69183df0)=SUCCESS
OCIAttrSet(7f9c69195010,OCI_HTYPE_STMT, 7fff5dc79728,4,Attr=OCI_ATTR_PREFETCH_ROWS,7f9c69183df0)=SUCCESS
cache settings DB Handle RowCacheSize=0,Statement Handle RowCacheSize=0, OCI_ATTR_PREFETCH_ROWS=60, OCI_ATTR_PREFETCH_MEMORY=0, Rows per Fetch=60, Multiple Row Fetch=Off
OCIDefineByPos(7f9c69195010,7f9c69824dc8,7f9c69183df0,1,7f9c691e4200,41,5,7f9c69824f70,7f9c69824ff0,7f9c698250d0,mode=DEFAULT,0)=SUCCESS
OCIDefineByPos(7f9c69195010,7f9c69824e70,7f9c69183df0,2,7f9c69824d90,0,108,7f9c69825150,7f9c698251d0,7f9c69825250,mode=DEFAULT,0)=SUCCESS
Field #2 is a object or colection of some sort. Using OCIDefineObject and or OCIObjectPin
At level=0 in description an embedded object
OCIAttrGet(7f9c69194b10,OCI_DTYPE_PARAM,7fff5dc79560,0,110,7f9c69183df0)=SUCCESS
OCITypeByRef(7f9c69160200,7f9c69183df0,7f9c691e6070)=SUCCESS
OCIDescribeAny(7f9c69173588,7f9c69183df0,7f9c691ff750,0,3,1,6,7f9c69191390)=SUCCESS
OCIAttrGet(7f9c69191390,OCI_HTYPE_DESCRIBE,7f9c69824cf0,0,OCI_ATTR_PARAM,7f9c69183df0)=SUCCESS
OCIAttrGet(7f9c69204640,OCI_DTYPE_PARAM,7fff5dc794d8,7fff5dc794d0,OCI_ATTR_SCHEMA_NAME,7f9c69183df0)=SUCCESS
OCIAttrGet(7f9c69204640,OCI_DTYPE_PARAM,7fff5dc794e0,7fff5dc794d4,OCI_ATTR_NAME,7f9c69183df0)=SUCCESS
OCIAttrGet(7f9c69204640,OCI_DTYPE_PARAM,7f9c69824d08,0,216,7f9c69183df0)=SUCCESS
Getting the properties of object named =DWHEELER.SYSTP3CQTeHmEOEjgQAAAAAAMiA== at level 0 typecode=122
Object named =DWHEELER.SYSTP3CQTeHmEOEjgQAAAAAAMiA== at level 0 is an Varray or Table
OCIAttrGet(7f9c69204640,OCI_DTYPE_PARAM,7f9c69824d0a,0,217,7f9c69183df0)=SUCCESS
OCIAttrGet(7f9c69204640,OCI_DTYPE_PARAM,7f9c69824cf8,0,227,7f9c69183df0)=SUCCESS
OCIAttrGet(7f9c692045f0,OCI_DTYPE_PARAM,7f9c69824d0c,0,216,7f9c69183df0)=SUCCESS
level=0 type_name = DWHEELER.SYSTP3CQTeHmEOEjgQAAAAAAMiA==
type_namel = 0
parmdp = 7f9c69204640
parmap = 7f9c692045f0
tdo = 7f9c691ff750
typecode = NAMEDCOLLECTION
col_typecode = 248
element_typecode = VARCHAR2
obj_ref = 0
obj_value = 0
obj_type = 0
is_final_type = 0
field_count = 0
fields = 0
--->done DWHEELER.SYSTP3CQTeHmEOEjgQAAAAAAMiA==
OCIOCIDefineObject(7f9c69191050,7f9c69183df0,7f9c691ff750)=SUCCESS
dbd_describe'd 2 columns (row bytes: 2040 max, 2040 est avg, cache: 0)
dbd_bind_ph(1): bind :p1 <== 'tryoracle' (type 0 (DEFAULT (varchar)))
dbd_rebind_ph() (1): rebinding :p1 as 'tryor...' (not-utf8, ftype 1 (VARCHAR), csid 0, csform 0(0), inout 0)
dbd_rebind_ph_char() (1): bind :p1 <== 'tryor...' (size 9/16/0, ptype 4(VARCHAR), otype 1 )
dbd_rebind_ph_char() (2): bind :p1 <== 'tryor...' (size 9/16, otype 1(VARCHAR), indp 0, at_exec 1)
bind :p1 as ftype 1 (VARCHAR)
OCIBindByName(7f9c69195010,7f9c69824c28,7f9c69183df0,":p1",placeh_len=3,value_p=7f9c69824da0,value_sz=16,dty=1,indp=7f9c69824c48,alenp=0,rcodep=7f9c69824c40,maxarr_len=0,curelep=0 (*=0),mode=DATA_AT_EXEC,2)=SUCCESS
OCIBindDynamic(7f9c69194cd0,7f9c69183df0,7f9c69824bf0,102194bb0,7f9c69824bf0,102194d30)=SUCCESS
OCIAttrGet(7f9c69194cd0,OCI_HTYPE_BIND,7f9c69824c0c,0,31,7f9c69183df0)=SUCCESS
dbd_rebind_ph(): bind :p1 <== 'tryor...' (in, not-utf8, csid 873->0->873, ftype 1 (VARCHAR), csform 0(0)->0(0), maxlen 16, maxdata_size 0)
OCIAttrSet(7f9c69194cd0,OCI_HTYPE_BIND, 7fff5dc798e4,0,Attr=31,7f9c69183df0)=SUCCESS
dbd_st_execute SELECT (out0, lob0)...
Statement Execute Mode is 0 (DEFAULT)
OCIStmtExecute(7f9c69173588,7f9c69195010,7f9c69183df0,0,0,0,0,mode=DEFAULT,0)=ERROR
OCIAttrGet(7f9c69195010,OCI_HTYPE_STMT,7fff5dc7993e,0,OCI_ATTR_PARSE_ERROR_OFFSET,7f9c69183df0)=SUCCESS
OCIErrorGet(7f9c69183df0,1,"<NULL>",7fff5dc795ac,"ORA-00932: inconsistent datatypes: expected - got -
",1024,2)=SUCCESS
OCIErrorGet(7f9c69183df0,2,"<NULL>",7fff5dc795ac,"ORA-00932: inconsistent datatypes: expected - got -
",1024,2)=NO_DATA
OCIHandleFree(7f9c69191390,OCI_HTYPE_DESCRIBE)=SUCCESS
dbd_st_destroy
OCIHandleFree(7f9c69195010,OCI_HTYPE_STMT)=SUCCESS
DBD::Oracle::db selectrow_hashref failed: ORA-00932: inconsistent datatypes: expected - got - (DBD ERROR: error possibly near <*> indicator at char 41 in '
SELECT c.change_id
, <*>COLLECT(t.tag) AS tags
FROM changes c
LEFT JOIN tags t ON c.change_id = t.change_id
WHERE c.project = :p1
GROUP BY c.change_id
') [for Statement "
SELECT c.change_id
, COLLECT(t.tag) AS tags
FROM changes c
LEFT JOIN tags t ON c.change_id = t.change_id
WHERE c.project = ?
GROUP BY c.change_id
"] at /Users/david/bin/try line 25.
OCISessionEnd(7f9c69173588,7f9c69183df0,7f9c691abe00,mode=DEFAULT 0)=SUCCESS
OCIServerDetach(7f9c69184e60,7f9c69183df0,mode=DEFAULT,0)=SUCCESS
OCIHandleFree(7f9c691abe00,OCI_HTYPE_SESSION)=SUCCESS
OCIHandleFree(7f9c69173588,OCI_HTYPE_SVCCTX)=SUCCESS
OCIHandleFree(7f9c69184e60,OCI_HTYPE_SERVER)=SUCCESS
OCIHandleFree(7f9c69183df0,OCI_HTYPE_ERROR)=SUCCESS
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment