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 :-)

Thanks for any help!

Brgds
IVer in Oslo
0
LVL 78

Comment

by:☠ MASQ ☠
Iver, use this link and ask a question of our Oracle experts
https://www.experts-exchange.com/askQuestion.jsp
0

Keep in touch with Experts Exchange

Tech news and trends delivered to your inbox every month