Re: bind datatype: dty=180

From: Vladimir Begun <Vladimir.Begun_at_oracle.com>
Date: Wed, 09 Mar 2005 14:05:30 -0800
Message-ID: <422F732A.3090609@oracle.com>

Igor Neyman wrote:
> What type is "dty=180"?

Oracle® Call Interface Programmer's Guide Internal Datatypes
TIMESTAMP 11 bytes 180

SQL> VAR v VARCHAR2(1000);
SQL> DECLARE
   2 d TIMESTAMP := SYSTIMESTAMP;
   3 BEGIN
   4 SELECT DUMP(d) INTO :v FROM dual;    5 END;
   6 /

PL/SQL procedure successfully completed.

SQL> print v

Typ=180 Len=11: 120,105,3,9,14,60,50,33,142,108,112

PARSING IN CURSOR #25 len=27 dep=1 uid=0 oct=3 lid=0 tim=109982911799 hv=1399250345 ad='10f1e198' SELECT DUMP(:B1 ) FROM DUAL
END OF STMT
PARSE #25:c=0,e=412,p=0,cr=0,cu=0,mis=1,r=0,dep=1,og=1,tim=109982911784 BINDS #25:
bind 0: dty=180 mxl=11(11) mal=00 scl=06 pre=00 oacflg=01 oacfl2=206001 size=12 offset=0 bfp=0725fbc4 bln=11 avl=11 flg=05
value=
Dump of memory from 0x0725FBC4 to 0x0725FBCF 725FBC0 09036978 281D050F 07402A1D [xi.....(.*@.]

-- 
Vladimir Begun
The statements and opinions expressed here are my own
and do not necessarily represent those of Oracle.

--
http://www.freelists.org/webpage/oracle-l

Received on Wed Mar 09 2005 - 17:07:29 CST