Getting data back into the OLEDBDATAAdapter's from

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
Iver Erling ArvaSenior consultantAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Daniel_PLDB Expert/ArchitectCommented:

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

Iver Erling ArvaSenior consultantAuthor 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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
☠ MASQ ☠Commented:
Glad you got it fixed Iver

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

EE- Topic Advisor
Iver Erling ArvaSenior consultantAuthor Commented:
It solved my problem
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today

From novice to tech pro — start learning today.