Writing Oracle External Procedures

[email protected] · Post by **[email protected]** » Wed 09 Jun 2010 13:51

Hi,
is it possible to get a sample on: how to writing Oracle External Procedures
with the dotconnect for Oracle Components.

best regards
Edgar

[email protected] · Post by **[email protected]** » Fri 11 Jun 2010 08:03

Hi,
is it possible to write Oracle External Procedures with dotConnect for Oracle?
And when yes, how to do it?

Please give me a little help.

best regards
Edgar

Shalex · Post by **Shalex** » Fri 11 Jun 2010 17:24

Here are the articles that describe creation and usage of Oracle External Procedures:
http://docstore.mik.ua/orelly/oracle/prog2/ch21_01.htm
http://www.datadisk.co.uk/html_docs/ora ... edures.htm

You can execute the PL/SQL commands via Devart.Data.Oracle.OracleCommand and OracleScript classes.

[email protected] · Post by **[email protected]** » Fri 11 Jun 2010 17:44

Thanks for the info.

I'm an avid user of your Oracle products VCL.
In the Demo of the VCL Products (...\Demos\Win32\Miscellaneous\ExternalProc\ExtProcClient)
is a wunderful Exsample, how to write external Procedures for Oracle.

There i can see how to load oci.dll and link OCI functions with InitOCI command.
Also how to set service context handle in OraSession.

In need the same functionality in dotConnect for Oracle.

can you please help with this functionality

( i am a beginner in the dotNet world)

Shalex · Post by **Shalex** » Mon 14 Jun 2010 14:39

Currently it is possible to create libraries with external procedures only using ODAC. You can create only managed code with dotConnect for Oracle. Here is the first problem: Oracle allows direct interoperation with managed assemblies that use only ODP.NET provider. It is possible to call managed assembly that uses dotConnect for Oracle via additional C++ library. If this approach suits your needs, we can try to resolve the second problem: setting service context handle in session. We will notify you about the results if the second problem can be solved.