I think the only way to make progress on this is if you can share the full source code of your test program. If you are willing to do that, do you have an e-mail address I can contact you on?
Thanks for your mail i am able to work on it now.
Now i am getting the error as space exhausted ORA-02356: TT0802: Database permanent space exhausted -- file "blk.c", lineno 3450, procedure "sbBlkAlloc"
which means that i am running out of the space , i have used 32 bit + windows so i can insert upto some 150K data in general.
Where as if i tried with ODP i am able to insert only 20k records why there is a huge difference even if i use Oracle namespace which the product of Oracle,i have tried with ODBC where i can able to insert upto 150k data i am facing this problem only in ODP
I have kept Perm size as 400 and temp size as 40 across all the connections(ODP and ODBC).
The memory for the database is allocated when the database is started up and is fixed in size. i.e. we allocate all 400 MB of Perm size up front. There should not be any difference between ODBC and ODP .NEt as long as you are able to establish the connection. My guess is that from your ODP .NET program you are connecting to a different DSN with a much smaller PermSize than the one you are using from ODBC. Check the TNS entry in your tnsnames.ora file to be sure it is pointing at the same DSN...