Re: Strange behaviour calling stored procedure from Pro*C

Sybrand Bakker wrote:

>
> I don't think globally temporay tables can be indexed. External tables
> can't

GTT's can be indexed - problem is how to calculated stats :)

SQL> create global temporary table gtt (col1 number, col2 varchar2(10))   2 on commit delete rows;
Table created.

SQL> create unique index pk_gtt on gtt (col1); Index created.

SQL> insert into gtt values(1,'one');
1 row created.

SQL> commit;
Commit complete.

This is 9.2.0.6

-- 
Regards,
Frank van Bortel

Top-posting is one way to shut me up...