Getting data back into the OLEDBDATAAdapter's system.data.datatable from OraOLEDB.oracle

Iver Erling Arva
Iver Erling Arva used Ask the Experts™
on
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 from the data connector, 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 my sql-string to achieve this. Creating an OS-file and send the result out there this way works fine, so the SQL-code executes as it should. But rather than doing that, it would be much more convenient and secure to do it directly into the system.data.datatable of OLEDBDATAAdapter. The calling software (Blue Prism) has methods to handle that input directly from the returned table.

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
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Daniel_PLDB Expert/Architect
Top Expert 2011
Commented:
Hi,

I needed something like this in powershell and used refcursor approach. Take a look here and see if it suits you.
http://www.oracle.com/technetwork/articles/dotnet/williams-refcursors-092375.html

Regards,
Daniel
Senior consultant
Commented:
Hi, Daniel and thanks for your suggestion. Refcursor is an interresting possibility, but unfortunately I think not a viable option in this particular case due to limitations in the environment I'm using. I have, however been able to get around the problem by rewriting the SQL-code, as it turned out that systematically sorting my different data combinations gave a simpler result than first anticipated.

Best regards
IVer
Most Valuable Expert 2013

Commented:
Glad you got it fixed Iver

I answered my own question. How do I close the question?

MASQUERAID
EE- Topic Advisor
Iver Erling ArvaSenior consultant

Author

Commented:
It solved my problem

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial