Re: bind datatype: dty=180

  • From: Vladimir Begun <Vladimir.Begun@xxxxxxxxxx>
  • To: "Oracle-L (E-mail)" <oracle-l@xxxxxxxxxxxxx>
  • Date: Wed, 09 Mar 2005 14:05:30 -0800

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

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.

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

Other related posts: