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