ADO and Oracle in VB 6.0
Hope ya'll had a great weekend.
I need some help from VB 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
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
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,
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.
-- Android Development Center
-- Cloud Development Project Center
-- HTML5 Development Center
-- Windows Mobile Development Center