Doa updatingtable

260 TOracle Provider reference.............................................................................................. 261 Unit reference................................................................................................................ 262 Direct Oracle Access Preferences ................................................................................... 266 Direct Oracle Access Designtime Property Defaults..........................................................268 Multi-threaded applications ............................................................................................. 269 Dynamic Link Libraries ................................................................................................... 270 Translating standard messages from English................................................................... 272 Oracle Net compatibility issues ....................................................................................... 274 Personal Oracle Lite compatibility issues .........................................................................

If you want to see if you have DB connection leaks then it is worth looking at this blog article: You need to implement a try / except block so that it always releases the connection "Just wanted to do some automation step its just for a demo to automate a problem resolution" There are blogs/technotes out on the IBM side that provide examples about the power of auto scripts.

Not all of them are great examples/code but they are present.

This gives you the following advantages: w No distributing, installing and configuring the BDE.

You can use any 32 bits Delphi or C Builder version to develop Client/Server applications w No BDE overhead or tradeoffs: your queries will run up to five times faster w Automatic Master/Detail configuration w Automatically enforce server-constraints on the client w Make use of server generated values (defaults, trigger modified columns) w Query By Example mode for high performance queryable forms without any programming w Use PL/SQL blocks for server logic in your application w Increase batch performance with Array DML or Direct Path Loading w Easily execute SQL scripts similar to SQL*Plus through the TOracle Script component w Monitor database access information with the Oracle Monitor utility w Access your stored packages easily through the TOracle Package component or the Package Wizard w Encapsulation of standard Oracle packages (dbms_alert, dbms_job, utl_file, ...) w Many Oracle specific features supported w Compatible with SQL*Net 1 thru Oracle Net 9, and with Personal Oracle Lite thru Oracle9i Component overview Direct Oracle Access consists of the following components: w You use the TOracle Session component to connect to an Oracle database and to control transactions.

11 TOracle Logon component ................................................................................................. 44 TOracle Logon reference ................................................................................................... 45 TOracle Query component ................................................................................................. 49 TOracle Query reference ................................................................................................... 60 TOracle Data Set component .............................................................................................. 89 TOracle Data Set reference................................................................................................ 92 TQBEDefinition object .................................................................................................... 131 TQBEDefinition reference ............................................................................................... 132 TQBEField object ........................................................................................................... 135 TQBEField reference...................................................................................................... 136 TOracle Navigator component .......................................................................................... 138 TOracle Package component ........................................................................................... 139 TOracle Package reference.............................................................................................. 141 TOracle Event component................................................................................................ 146 TOracle Event reference.................................................................................................. 147 TLOBLocator.................................................................................................................. 152 TLOBLocator reference................................................................................................... 157 TOracle Object object...................................................................................................... 164 TOracle Object reference................................................................................................. 166 TOracle Reference object ................................................................................................ 180 TOracle Reference reference........................................................................................... 181 TOracle Script component................................................................................................ 184 TOracle Script reference.................................................................................................. 187 TOracle Commands object............................................................................................... 195 TOracle Commands reference......................................................................................... 196 TOracle Command object ................................................................................................ 198 TOracle Command reference........................................................................................... 199 TOracle Direct Path Loader component ..............................................................................

203 TOracle Direct Path Loader reference................................................................................. 206 TDirect Path Columns object............................................................................................. 211 TDirect Path Columns reference........................................................................................ 212 TDirect Path Column object .............................................................................................. 213 TDirect Path Column reference ......................................................................................... 214 TOracle Queue component .............................................................................................. 216 TOracle Session Pool component...................................................................................... 229 TOracle Timestamp object ............................................................................................... 235 TOracle Timestamp reference.......................................................................................... 236 TXMLType object ........................................................................................................... 240 TXMLType reference...................................................................................................... 241 The Package Wizard ...................................................................................................... 242 TOracle Custom Package component................................................................................ 251 TOracle Custom Package reference.................................................................................. 252 TPLSQLRecord object.................................................................................................... 254 TPLSQLRecord reference............................................................................................... 255 TPLSQLTable object ...................................................................................................... 256 TPLSQLTable reference ................................................................................................. 257 4 Direct Oracle Access 4.0 - User's Guide TOracle Provider component ...........................................................................................

276 Index ............................................................................................................................. 277 Direct Oracle Access 4.0 - User's Guide 5 Direct Oracle Access VERSION 4.0, AUGUST 2003 If you use Delphi or C Builder to access an Oracle database, this component set can make your life a lot easier.

With the Direct Oracle Access components and objects you access an Oracle database directly, skipping the Borland Database Engine, only using SQL*Net.

Please help me with same sample script, till the change get approved I have already implemented.

Tags: , ,