Additional
Overview
Features
Known issues
FAQ
Support
Credits and license
History
Download
Forum
FAQ
Why freeware and how long time NCOCI8 will remain freeware ?
Sep 19, 2006
Main goal for me, when I made NCOCI8 freeware, was and is now - to develop best access from Delphi to Oracle for my company projects. Where I can find so many beta testers, as I find in INet ?! Also, NCOCI8 is my hobby. How long ? Forever... "The train already has left" at the moment, when I made NCOCI8 freeware.
 
Can I join to NCOCI8 development team ?
Sep 19, 2006
Yes ! Anybody, who know Oracle server and can develop Delphi components, also can join to NCOCI8 development team. There is a lot of work.
 
Where I can find valid version number of NCOCI8 ?
Sep 19, 2006
See title of readme.txt file.
 
Can I use NCOCI8 in commercial applications ?
Sep 19, 2006
Freely, without any payments. But You must to put next strings in applications About screen: 
Contains NCOCI8 - direct access from Delphi to Oracle8 
(c) 1999-2007, Dmitry Arefiev
 
In DOA and other component librarys for direct access exists light wheighted query component ...
Sep 19, 2006
In DOA and other component librarys for direct access exists light wheighted query component. In DOA - TOracleQuery. Why NCOCI8 does not have one ?
[read more...]
 
Can i use NCOCI8 with Oracle7 server ?
Sep 19, 2006

Yes. You can, but there are some requirements and limitations:

  • you must have installed Oracle8 client software;
  • you can't use Oracle8 specific features, such as data types BLOB/CLOB/BFILE, RETURNING phrase;
  • you can't use TOCIStoredProc;
  • you can't use TOCITransactionManager.
 
Can i use NCOCI8 with Oracle client software v 8.0.3 ?
Sep 19, 2006
Yes. You can, but only from NCOCI8 v 0.7.5. Also, better to migrate to Oracle client software v 8.0.4 or higher. It is because, v 8.0.3 is very unstable release.
 
How i can create NT service application ?
Sep 19, 2006

Yes. That is easy. First at all take a look on demo application Services. Main properties there are in TOCIDatabase:

  • SilentMode = True 
  • InitModes = [dmThreaded]
 
How i can create 3-tier application with NCOCI8 in server part ?
Sep 19, 2006

For that you should use: 

  • - MIDAS 3 technology; 
  • - or ASTA. 

NCOCI8 has buildin support for that tools. Also you probably can use something other tool, but in that case you will create support for this tool. For details, about how to setup MIDAS server, see demo project MIDAS.

 
I get "... Error while loading OCI.dll". What i should do ?
Sep 19, 2006
First at all take a look on how NCOCI8 load OCI.DLL. OCI.DLL is Oracle8 client side - OCI library. That is documented (right) way to use Oracle client.
[read more...]
 
I want to use TOCIQuery to execute CREATE OR REPLACE PACKAGE ... WRAPPED ...
Sep 19, 2006
I want to use TOCIQuery to execute CREATE OR REPLACE PACKAGE ... WRAPPED command, but i am getting errors. What is wrong ?
[read more...]
 
After call of TOCIQuery.Refresh data set jumps to first record ...
Sep 19, 2006
After call of TOCIQuery.Refresh data set jumps to first record. How i can preserve current position ?
[read more...]
 
Is it possible to have autonumber fields in oracle and if so how does one make a field autonumber?
Sep 19, 2006
[read more...]
 
During Post or ApplyUpdates i get NOE129/Q exception. What this mean ?
Sep 19, 2006
[read more...]
 
How to setup TOCIQuery to use stored proc for posting updates ?
Sep 19, 2006
See ProcUpd demo. It implements such technique. In general you should use TOCIQuery linked with TOCIUpdateSQL. TOCIUpdateSQL have properties SQLUpdate, SQLInsert, etc. To some of them you should assign PL/SQL anonymous block, that will call stored procedure. To transmit old field values use parameters with prefix OLD_, for new field values - use field names as parameter names or prefix it with NEW_.
 
I cant edit TOCIQuery, that have SQL with ORDER BY. What i shall do ?
Sep 19, 2006
Update your NCOCI8 version to 1.0.0
 
When i close TOCIQuery, i see in select * from v$open_cursor, that cursor remains opened ...
Sep 19, 2006
When i close TOCIQuery, i see in select * from v$open_cursor, that cursor remains opened. Is that a bug or something else ?
[read more...]
 
I get error "ORA-01000: maximum open cursors exceeded". What i must to do ?
Sep 19, 2006

You have too many open cursors. NCOCI8 opens cursor each time, when call to Open / Prepare happens. You have follows options to solve this issue:

  1. Close and UnPrepare unused TOCIQuery / TOCIStoredProc (see Q 5.1); 
  2. Set OPEN_CURSORS to some greater value 
  3. Set TOCIDataSet.Disconnectable = True for datasets, that NCOCI8 can Close/Unprepare without problems. And set TOCIDatabase.MaxCursors to maximum allowed count of open cursors. When count of prepared TOCIDataSet will grow up to TOCIDatabase.MaxCursors, NCOCI8 will run automatic dataset disconnection process.
 
I must download big dataset to client. But after 30.000 records i am going off memory ...
Sep 19, 2006
 I must download big dataset to client. But after 30.000 records i am going off memory. What i shoold do ?
[read more...]
 
TOCIDatabase show login dialog, but TOCIQuery.Active = False and TOCIDatabase.Connected = False ...
Sep 19, 2006
I create simple application: DM with TOCIDatabase, Form with TOCIQuery. In first time i set TOCIDatabase.Connected = False. Then i open TOCIQuery and close it, after that made TOCIDatabase.Connected = False. And save project. Now when i open Form, TOCIDatabase show login dialog, but TOCIQuery.Active = False and TOCIDatabase.Connected = False ! What is wrong ?
[read more...]
 
What i must setup to work with CHAR data type.
Sep 19, 2006
You must set TOCIDatabase.DefaultDataFormat.EnableFixedString = True or TOCIDataSet.DataFormat.EnableFixedString = True. After that your application will correctly handle CHAR data type. NCOCI8 will automatically take care about padding values with spaces upto DataSize.
 
I set DataBase. DefaultDataFormat. EnableLongString := True, but i can't assign strings ...
Sep 19, 2006
I set DataBase. DefaultDataFormat. EnableLongString := True, but i can't assign strings with length more than 255. I get NOE10/VAR.
[read more...]
 
My MIDAS server has strange bug - all TOCIQuery from different RDM are binded to first ...
Sep 19, 2006
My MIDAS server has strange bug - all TOCIQuery from different RDM are binded to first TOCIDatabase from first created RDM. What is wrong ?
[read more...]