<div>
Glad you got it fixed Iver<br />
<br />
<a href="http://support.experts-exchange.com/customer/en/portal/articles/626549-i-answered-my-own-question-how-do-i-close-the-question-?b_id=44" rel="ugc nofollow">I answered my own question. How do I close the question?</a><br />
<br />
MASQUERAID<br />
EE- Topic Advisor
</div>


<div>
<div class="content wysiwyg-content">
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.<br />
<br />
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.<br />
<br />
Can anyone give any advice as how to achieve this? As you probably understand, this isn't my main area of expertise :-)<br />
<br />
Thanks for any help!<br />
<br />
Brgds<br />
IVer in Oslo
</div>
</div>


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

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

Software is any set of instructions that directs a computer to perform specific tasks or operations. Computer software consists of programs, libraries and related non-executable data (such as documentation). Computer software is non-tangible, contrasted with computer hardware, which is the physical component of computers. Software written in a machine language is known as "machine code". However, in practice, software is usually written in high-level programming languages than machine language. High-level languages are translated into machine language using a compiler or interpreter or a combination of the two.

Software

Operating systems perform basic tasks, such as recognizing input from the keyboard, sending output to the display screen, keeping track of files and directories on the disk, and controlling peripheral devices such as disk drives and printers. For large systems, the operating system makes sure that different programs and users running at the same time do not interfere with each other. The operating system is also responsible for security, ensuring that unauthorized users do not access the system. Operating systems provide a software platform on top of which other programs, called application programs, can run.

Operating Systems

C# is an object-oriented programming language created in conjunction with Microsoft’s .NET framework. Compilation is usually done into the Microsoft Intermediate Language (MSIL), which is then JIT-compiled to native code (and cached) during execution in the Common Language Runtime (CLR).

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.

Microsoft SQL Server

Visual Basic .NET (VB.NET) is an object-oriented programming language implemented on the .NET framework, but also supported on other platforms such as Mono and Silverlight. Microsoft launched VB.NET as the successor to the Visual Basic language. Though it is similar in syntax to  Visual Basic pre-2002, it is not the same technology,

Visual Basic.NET

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.