Hi guys
Hope ya'll had a great weekend.
I need some help from ASP and Oracle guru's.
I am tryin to create temp table on the fly in oracle from ASP and then
inserting records into the temp table using a sub query.
The temp table gets created but when I insert the records and try to get
the
records there are no records inserted.
But if I do this from PL/SQL Developer GUI it works fine.
I referred the ORA OLEDB documentation, it says that I have to use ADO
Command object, but there is no thing for sub Query's tho.
I am using ADO 2.7.
------
The Sql is as follows
To create table
CREATE GLOBAL TEMPORARY TABLE SEC_FILTER_USERNAME (PROP_NO CHAR(10)) ON
COMMIT DELETE ROWS
and the insert Sql is
INSERT INTO SEC_FILTER_GRAJPUT SELECT PROP_NO FROM CT_MAIN WHERE
INST_CODE='BIGBUCKS'
Now the as per the ORA OLEDB documentation I have to create Command object,
set all the properties and then execute the INSERT Sql.
'set the active connection and other details for CO
oCom.CommandType = adCmdText
Set oParaPropNo = oCom.CreateParameter("oParaPropNo", adChar, adParamInput,
10)
------
Now the last parameter in CreateParameter is the value of the oParaPropNo
object which in my case is a subquery.
And that's where I am stuck

Any help is appreciated.

Thanks