Getting data back into the OLEDBDATAAdapter's from

Iver Erling Arva
Iver Erling Arva used Ask the Experts™
Hi! To avoid going via a OS file, I want to write my Oracle script's output directly to the OLEDBDATAAdapter 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 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!

IVer in Oslo
Watch Question

Do more with

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

I needed something like this in powershell and used refcursor approach. Take a look here and see if it suits you.

Senior consultant
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
Most Valuable Expert 2013

Glad you got it fixed Iver

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

EE- Topic Advisor
Iver Erling ArvaSenior consultant


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