|
|
|
FAQ
|
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. |
|
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. |
|
Sep 18, 2006 |
|
See title of readme.txt file. |
|
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 |
|
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 ? |
|
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.
|
|
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. |
|
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]
|
|
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. |
|
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. |
|
Sep 18, 2006 |
|
I want to use TOCIQuery to execute CREATE OR REPLACE PACKAGE ... WRAPPED command, but i am getting errors. What is wrong ? |
|
Sep 18, 2006 |
|
After call of TOCIQuery.Refresh data set jumps to first record. How i can preserve current position ? |
|
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_. |
|
Sep 18, 2006 |
|
Update your NCOCI8 version to 1.0.0 |
|
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 ? |
|
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: - Close and UnPrepare unused TOCIQuery / TOCIStoredProc (see Q 5.1);
- Set OPEN_CURSORS to some greater value
- 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.
|
|
Sep 18, 2006 |
|
I must download big dataset to client. But after 30.000 records i am going off memory. What i shoold do ? |
|
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 ? |
|
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. |
|
Sep 18, 2006 |
|
I set DataBase. DefaultDataFormat. EnableLongString := True, but i can't assign strings with length more than 255. I get NOE10/VAR. |
|
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 ? |
| |
|
|