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.
Top DevX Stories
Easy Web Services with SQL Server 2005 HTTP Endpoints
JavaOne 2005: Java Platform Roadmap Focuses on Ease of Development, Sun Focuses on the "Free" in F.O.S.S.
Wed Yourself to UML with the Power of Associations
Microsoft to Add AJAX Capabilities to ASP.NET
IBM's Cloudscape Versus MySQL