Writing Oracle External Procedures

Writing Oracle External Procedures

Postby 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

Postby 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
edgar.sperling@online.de
 
Posts: 6
Joined: Sun 11 Dec 2005 10:21

Postby 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.
Shalex
Devart Team
 
Posts: 7781
Joined: Thu 14 Aug 2008 12:44

Postby 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)
edgar.sperling@online.de
 
Posts: 6
Joined: Sun 11 Dec 2005 10:21

Postby 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.
Shalex
Devart Team
 
Posts: 7781
Joined: Thu 14 Aug 2008 12:44


Return to dotConnect for Oracle