Additional
Overview
Features
Get
Discuss
News
Known issues
FAQ
Support
Credits and license
FAQ
Why freeware and how long time NCOCI8 will remain freeware ?
Sep 18, 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 18, 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 18, 2006
See title of readme.txt file.
 
Can I use NCOCI8 in commercial applications ?
Sep 18, 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 18, 2006
In DOA and other component librarys for direct access exists light wheighted query component. In DOA - TOracleQuery. Why NCOCI8 does not have one ?
 
Can i use NCOCI8 with Oracle7 server ?
Sep 18, 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 18, 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 18, 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 18, 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 18, 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.
 
I want to use TOCIQuery to execute CREATE OR REPLACE PACKAGE ... WRAPPED ...
Sep 18, 2006
I want to use TOCIQuery to execute CREATE OR REPLACE PACKAGE ... WRAPPED command, but i am getting errors. What is wrong ?
 
After call of TOCIQuery.Refresh data set jumps to first record ...
Sep 18, 2006
After call of TOCIQuery.Refresh data set jumps to first record. How i can preserve current position ?
 
How to setup TOCIQuery to use stored proc for posting updates ?
Sep 18, 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 18, 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 18, 2006
When i close TOCIQuery, i see in select * from v$open_cursor, that cursor remains opened. Is that a bug or something else ?
 
I get error "ORA-01000: maximum open cursors exceeded". What i must to do ?
Sep 18, 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 18, 2006
 I must download big dataset to client. But after 30.000 records i am going off memory. What i shoold do ?
 
TOCIDatabase show login dialog, but TOCIQuery.Active = False and TOCIDatabase.Connected = False ...
Sep 18, 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 ?
 
What i must setup to work with CHAR data type.
Sep 18, 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 18, 2006
I set DataBase. DefaultDataFormat. EnableLongString := True, but i can't assign strings with length more than 255. I get NOE10/VAR.
 
My MIDAS server has strange bug - all TOCIQuery from different RDM are binded to first ...
Sep 18, 2006
My MIDAS server has strange bug - all TOCIQuery from different RDM are binded to first TOCIDatabase from first created RDM. What is wrong ?