Getting data back into the OLEDBDATAAdapter's system.data.datatable from OraOLEDB.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 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
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:
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
1
 
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
IVer
0

Experts Exchange Solution brought to you by ConnectWise

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?

MASQUERAID
EE- Topic Advisor
0
 
Iver Erling ArvaSenior consultantAuthor Commented:
It solved my problem
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.