System requirementsDirect Oracle Access
If you are using Borland's Delphi or C++Builder to develop Oracle applications, then the Direct Oracle Access component set can help you to make a seamless integration between this great development tool and database system. Not only will your application take maximum advantage of both products, your application development process will also benefit from the following key features: High performance
Both online transaction and batch processing applications can benefit from Oracle's performance features. Direct Oracle Access, as the name suggests, directly accesses the Oracle Interface. This guarantees optimal performance for standard database access functions. Support for Array Fetching, Array DML, PL/SQL Blocks, PL/SQL Tables, Local Statement Caching and the Direct Path Load Engine enable you to optimize your application's performance critical functions even more.
High performanceEasy application distribution
A Direct Oracle Access application does not require middleware like the BDE or ODBC, it merely requires Oracle SQL*Net or Net8. Consequently you can deploy your application without many of the version dependency or configuration problems typically involved with middleware installation.
Application distributionOracle Package support
Most PL/SQL code in Oracle databases is programmed in packages. Direct Oracle Access provides a TOraclePackage component that allows you to easily call packaged program units without detailed declarations of these program units and their parameters.
Furthermore Direct Oracle Access includes a Package Wizard that can generate classes to encapsulate the program units and record types defined in packages. This will make your Oracle packages a natural extension of the Object Pascal or C++ language.
The Package WizardTOracleDataSet
The dataset component in Direct Oracle Access supports Oracle record locking, record refreshing, server generated values, automatic sequence value generation, and BLOB compression. Master/detail relations can automatically be setup if a foreign key exists between the master and detail table or if the master table contains one or more collection columns or attributes (nested table or varray).
The TOracleDataSet can use much of the information in the Oracle Dictionary at run time. Server Constraints can be checked on the client, and constraint error messages can be read from a message table. Format masks, range values and default values can also be read from the dictionary. This allows you to create applications with a minimum amount of 'database knowlegde' compiled into the executable, dynamically adopting changes in the database without even recompiling it.
The TOracleDataSetQuery By Example mode
The TOracleDataSet component has a Query By Example mode that enables you to provide QBE Forms in your application without any additional programming, and without any additional components or controls. The resulting QBE queries are performed on the Oracle Server, so that performance will be optimal and network traffic will be minimal. The user can supply simple query values such as JONES or 100, can include wildcard characters for string values such as JON%, and can include comparison operators such as >, <, NOT, BETWEEN, IN and so on.
Query By ExampleOracle Monitor
To monitor the database access activities of your Direct Oracle Access application you can use the Oracle Monitor utility. It displays the SQL, variables, timestamp, elapsed time, network statistics, database statistics and query execution plan of each activity. This can be helpful to find performance bottlenecks, for tuning purposes, and to solve application errors.
The Oracle MonitorAlert and Pipe events
The Oracle Server includes a dbms_alert and dbms_pipe package for event processing. The TOracleEvent in Direct Oracle Access can function as a receiver for these events. It works in a background thread of your application, and can propagate database events to the familiar object events. These events can occur synchronously or asynchronously with the main thread of your application.
Alert and Pipe eventsSQL scripts
If you need to execute many data definition language (DDL) statements, for example to perform the database installation part of your application, you can use the TOracleScript component. It has a property editor that allows you to develop the script and the individual commands. The extendible script language follows the basic SQL*Plus syntax and supports all SQL statements. It also supports substitution variables to make your scriptscustomizable.
SQL ScriptsAdvanced Queueing
To take advantage of the Advanced Queuing option of Oracle8 you can make use of the TOracleQueue component. The TOracleQueue component encapsulates the basic functionality of the DBMS_AQ package. It provides a convenient way to enqueue messages into a queue or to dequeue messages from a queue. Messages can be dequeued in a background thread of your application, and the events that are generated in threaded mode can occur synchronously or asynchronously with the main thread of your application.Session Pooling
In server applications that frequently need to create sessions to process requests from client applications, it may be useful to use connection pooling. Without a pooling concept, each request could lead to an actual database logon and logoff. By using the TOracleSessionPool component, you can maintain a pool of database sessions that can be used and reused for different requests. You can define the minimum an maximum number of sessions in the pool, define the TimeOut behavior for idle sessions in the pool, and preset the username, password and database.Support for Oracle specific features
Direct Oracle Access supports many Oracle specific features. Besides the features mentioned above, it supports Oracle8 and Oracle8i features like LOB Locators, Objects & References, XMLTYPE, Timestamps, Scrollable Queries, Password Expiration, External Procedure development, and the Oracle Services for MTS.
Direct Oracle Access requires a Windows 95, 98, ME, NT4, 2000, XP, Vista or Windows 7 client, with a 32 bit SQL*Net, Net 8, Net 9, Net 10 or Net 11 installed. The supported Oracle Server versions are 7.x, 8.x, 8i, 9i, 10g and 11g on any platform. Direct Oracle Access is available for all recent versions of Delphi and C++Builder.
Standard or Object version
The Direct Oracle Access components are available in two versions, the Standard version and the Object version. The Object version allows you to use Oracle8's Object extension through the TOracleObject and TOracleReference objects.
Oracle Monitor Pro option
The Oracle Monitor allows you to monitor the database activities that your Direct Oracle Access applications generate. The Lite version is available for free, and the Pro version can be purchased as an option for a Direct Oracle Access license. The Pro version includes additional features like database and network statistics, and query plan analysis.
Service Contract option
If you order an Annual Service Contract for a Direct Oracle Access license, you are entitled to technical support by e-mail and free product upgrades for the period of 1 year. Without this contract, you will receive only patch releases of the Direct Oracle Access version you purchased.
You can order the service contract directly with Direct Oracle Access or at a later time. The service contract can be renewed when it expires after 1 year.
Sourcecode option
You can additionally order the Sourcecode option, which is not related to the number of Direct Oracle Access licenses. Direct Oracle Access is programmed in Delphi, but the sourcecode can be compiled in C++Builder as well.
교환 및 반품이 가능한 경우
- 상품을 공급 받으신 날로부터 7일이내 단, 가전제품의
경우 포장을 개봉하였거나 포장이 훼손되어 상품가치가 상실된 경우에는 교환/반품이 불가능합니다.
- 공급받으신 상품 및 용역의 내용이 표시.광고 내용과
다르거나 다르게 이행된 경우에는 공급받은 날로부터 3월이내, 그사실을 알게 된 날로부터 30일이내
교환 및 반품이 불가능한 경우
- ESD(Electronic Software Distribution), 이메일로 설치key, 설치파일 또는 사용증서로 납품되는 제품의 경우는 제품 자체에 심각한 문제가 있는 경우를 제외하고는
반품이 불가 합니다.
- 고객님의 책임 있는 사유로 상품등이 멸실 또는 훼손된 경우. 단, 상품의 내용을 확인하기 위하여
포장 등을 훼손한 경우는 제외
- 포장을 개봉하였거나 포장이 훼손되어 상품가치가 상실된 경우
(예 : 가전제품, 식품, 음반 등, 단 액정화면이 부착된 노트북, LCD모니터, 디지털 카메라 등의 불량화소에
따른 반품/교환은 제조사 기준에 따릅니다.)
- 고객님의 사용 또는 일부 소비에 의하여 상품의 가치가 현저히 감소한 경우 단, 화장품등의 경우 시용제품을
제공한 경우에 한 합니다.
- 시간의 경과에 의하여 재판매가 곤란할 정도로 상품등의 가치가 현저히 감소한 경우
- 복제가 가능한 상품등의 포장을 훼손한 경우
(자세한 내용은 고객만족센터 Q&A게시판 또는 E-MAIL상담을 이용해 주시기 바랍니다.)
※ 고객님의 마음이 바뀌어 교환, 반품을 하실 경우 상품반송 비용은 고객님께서 부담하셔야 합니다.
(색상 교환, 사이즈 교환 등 포함)