Experts Exchange > Posts > Hi! To avoid going via a OS file, I want to write my Oracle …
Hi! To avoid going via a OS file, I want to write my Oracle script's output directly to the OLEDBDATAAdapter system.data.datatable from Oracle OraOLEDB.Oracle.
When I send a regular SELECT...someting, it is returned fine. However, I need to do some additional tweaking after that, so I am using a procedure and some additional code in SQL to achieve this. Creating an OS-file and send the result out there, works fine. But rather than doing that, it would be much more convenient and secure to do it directly into the system.data.datatable of OLEDBDATAAdapter.
Can anyone give any advice as how to achieve this? As you probably understand, this isn't my main area of expertise :-)
So this year I decided it was really about time I applied for the
@vExpert subprograms, and guess what! I'm in! So Thanks to our Programme Manager @vCommunityGuy and Sub Programme Business Units!