Hi guys
I am creating a temporary table with one column and then inserting records into the temp table using a subquery.
I am using ADO 2.7, the problem is it creates the temp table but when i do a insert, it is not inserting records into the temp table.
If I do this from oracle GUI it works fine( i am using PL/SQL Developer from allround automations)
The syntax is
CREATE GLOBAL TEMPORARY TABLE SEC_FILTER_USERNAME(PROP_NO CHAR(10))
INSERT INTO SEC_FILTER_GRAJPUT SELECT PROP_NO FROM CT_MAIN WHERE INST_CODE='BIGBUCKS'

Any help is appreciated.

Thanks