Re: DLL with PL/SQL ?
Date: Fri, 18 Jun 1999 14:55:49 +0100
Message-ID: <7kdf84$mfc$1_at_elle.eunet.no>
Content-Type: text/plain;
charset="iso-8859-1"
[Quoted] Content-Transfer-Encoding: quoted-printable
You can use 0040 (Oracle Objects for OLE) in any language supporting = OLE/COM (Visual Basic, C++, Delphi and more ) to write your DLL.
From the OO4O online doc :
The OO4O Automation Server is a set of COM Automation Objects for = connecting to Oracle database servers, executing SQL statements and = PL/SQL blocks, and accessing the results.=20
Unlike other COM-based database connectivity APIs, such as Microsoft = ADO, the OO4O Automation Server has been developed and evolved = specifically for use with Oracle database servers. It provides an = optimized API for accessing features that are unique to Oracle and are = otherwise cumbersome or inefficient to use from ODBC or OLE DB = components.
OO4O provides key features for accessing Oracle databases efficiently = and easily in environments ranging from the typical two-tier = client/server applications, such as those developed in Visual Basic or = Excel, to application servers deployed in multi-tiered application = server environments such as web server applications in Microsoft = Internet Information Server (IIS) or Microsoft Transaction Server (MTS). =
Features include:
=B7 Full Support for Oracle Object-Relational and LOB Datatypes=20
=B7 PL/SQL Support for execution of PL/SQL anonymous blocks and stored = procedures. This includes support for Oracle datatypes allowed for = input/output parameters of PL/SQL stored procedures including PL/SQL = cursors.=20
=B7 Support for scrollable and updatable cursors for easy and efficient = access to result sets of queries. Refer to OraDynaset.
=B7 Thread Safe objects and Connection Pool Management Facility for = developing efficient web server applications.
=B7 Full support for Advanced Queuing in Oracle.
=B7 Support for array inserts and updates. Refer to OraParameter, = OraParamArray, and OraSQLStmt.
=B7 Support for Microsoft Transaction Server (MTS).=20
regards
Hans
------=_NextPart_000_0014_01BEB99A.A702E700
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD W3 HTML//EN">
<HTML>
<HEAD>
<META content=3Dtext/html;charset=3Diso-8859-1 =
http-equiv=3DContent-Type>
<META content=3D'"MSHTML 4.72.3110.7"' name=3DGENERATOR>
</HEAD>
<BODY>
<DIV>You can use 0040 (Oracle Objects for OLE) in any language =
supporting=20
OLE/COM (Visual Basic, C++, Delphi and more ) to write your DLL.</DIV>
<DIV> </DIV>
<DIV>From the OO4O online doc :</DIV>
<DIV> </DIV>
<DIV><EM>The OO4O Automation Server is a set of COM Automation Objects =
for=20
connecting to Oracle database servers, executing SQL statements and =
PL/SQL=20
blocks, and accessing the results. </EM></DIV>
<DIV><EM></EM> </DIV>
<DIV><EM>Unlike other COM-based database connectivity APIs, such as =
Microsoft=20
ADO, the OO4O Automation Server has been developed and evolved =
specifically for=20
use with Oracle database servers. It provides an optimized API for =
accessing=20
features that are unique to Oracle and are otherwise cumbersome or =
inefficient=20
to use from ODBC or OLE DB components.</EM></DIV>
<DIV><EM></EM> </DIV>
<DIV><EM>OO4O provides key features for accessing Oracle databases =
efficiently=20
and easily in environments ranging from the typical two-tier =
client/server=20
applications, such as those developed in Visual Basic or Excel, to =
application=20
servers deployed in multi-tiered application server environments such as =
web=20
server applications in Microsoft Internet Information Server (IIS) or =
Microsoft=20
Transaction Server (MTS). </EM></DIV>
<DIV><EM></EM> </DIV>
<DIV><EM>Features include:</EM></DIV>
<DIV><EM></EM> </DIV>
<DIV><EM>· Full Support for Oracle Object-Relational and LOB =
Datatypes=20
</EM></DIV>
<DIV><EM></EM> </DIV>
<DIV><EM>· PL/SQL Support for execution of PL/SQL anonymous =
blocks and=20
stored procedures. This includes support for Oracle datatypes allowed =
for=20
input/output parameters of PL/SQL stored procedures including PL/SQL =
cursors.=20
</EM></DIV>
<DIV><EM></EM> </DIV>
<DIV><EM>· Support for scrollable and updatable cursors for easy =
and=20
efficient access to result sets of queries. Refer to =
OraDynaset.</EM></DIV>
<DIV><EM></EM> </DIV>
<DIV><EM>· Thread Safe objects and Connection Pool Management =
Facility=20
for developing efficient web server applications.</EM></DIV>
<DIV><EM></EM> </DIV>
<DIV><EM>· Full support for Advanced Queuing in =
Oracle.</EM></DIV>
<DIV><EM></EM> </DIV>
<DIV><EM>· Support for array inserts and updates. Refer to =
OraParameter,=20
OraParamArray, and OraSQLStmt.</EM></DIV>
<DIV><EM></EM> </DIV>
<DIV><EM>· Support for Microsoft Transaction Server (MTS). =
</EM></DIV>
<DIV><EM></EM> </DIV>
<DIV><EM></EM> </DIV>
<DIV>regards</DIV>
<DIV>Hans</DIV></BODY></HTML>
------=_NextPart_000_0014_01BEB99A.A702E700-- Received on Fri Jun 18 1999 - 15:55:49 CEST