code contents and anydata/anyset

[sukhadukkham]

the code contents is not displayed with anydata and anydataset.

1. open a new sqlwindow
2. write "anydata"
3. mark "anydata", right click => view

regards
daniel

 

[sukhadukkham]

another issue with anydata:

create table A
(
A ANYDATA,
)
tablespace BASIC
/
INSERT INTO a ( a ) VALUES ( SYS.anydata.convertnumber(1) );
INSERT INTO a ( a ) VALUES ( SYS.anydata.convertvarchar2('1') );
INSERT INTO a ( a ) VALUES ( SYS.anydata.convertdate(SYSDATE) );

do a select * from a sql-window => you will only see the rowid column.

regards
daniel

 

[Marco Kalter]

There is indeed no explicit support for the anydata type. This is on the to-do list though.

 

[sukhadukkham]

thank you for the response

 

[ed10k]

Version 7.1.4.1389
Database 10.2.0.2.0

SELECT * FROM DBA_SQLTUNE_BINDS;

OCI-21500: internal error code, arguments: [koiocon: opq] ...

 

[jonearles]

Any chance this can get added in the near future? I understand it may be difficult to display the contents of an ANYDATA. But it would be very helpful if at least the column name was displayed.

Thanks,
Jon

 

[Marco Kalter]

Yes, this is indeed still on the to-do list for a future release.