Writing Oracle External Procedures

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for Oracle
Post Reply
edgar.sperling@online.de
Posts: 6
Joined: Sun 11 Dec 2005 10:21

Writing Oracle External Procedures

Post by edgar.sperling@online.de » 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

edgar.sperling@online.de
Posts: 6
Joined: Sun 11 Dec 2005 10:21

Writing Oracle External Procedures

Post by edgar.sperling@online.de » 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
Site Admin
Posts: 8241
Joined: Thu 14 Aug 2008 12:44

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.

edgar.sperling@online.de
Posts: 6
Joined: Sun 11 Dec 2005 10:21

Post by edgar.sperling@online.de » 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
Site Admin
Posts: 8241
Joined: Thu 14 Aug 2008 12:44

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.

Post Reply