Recent content by al0

  1. A

    BLOCKS and NUM_ROWS

    Direct path load in Oracle is intended and optimized formass load. There is no sense to use it for inserting of couple of rows. Use normal inserts instead. Check "Direct path INSERT" topic in Oracle Concept guide (part of Oracle documentation set, available from otn.oracle.com).
  2. A

    Cant update the table with a date

    You just need not that format - your variable is declared as date so it is really date and not its string represantation, so data is transferred to Oracle in date internal format and not as string, so formatting is not applicable there. BTW, it is much more preferrableand safer way comparing...
  3. A

    Transaction in stored procedure

    Looks quite weird. Can you post sample code (or mail it to me)?
  4. A

    Console Application and DOA

    It is not a basd idesa to create an object before use it (this is applacable to any object, not to DOA objects only!). TOracleSession * theSession; doesn't create an object, theSession is only a pointer for object of TOracleSession type, and it is uninitialized. To initialize it you shall or...
  5. A

    limit and oracle version

    I assume you want to know how many records a query will return, without actually fetching all of them. You could do a select count(*) from (). For Oracle prior to 9.2 - no way, Oracle does not support such feature, for 9.2/10 you may use scrollable cursors (as Marco has mentioned) but their...
  6. A

    TOracleQuery - Open Cursor Problem

    Triggers are just regular PL/SQL code and cursors in them behave in absolutely standard waz. Particulary, if you have opened and explicit cursor in trigger (or any other PL/SQL block) you have explicitely close that cursor, regardless has trigger finished normally or it has raised an exception...
  7. A

    4.0.6.2.

    Nothing has changed is 10 days - if you download you have 4.0.6.2 but download page still annonce 4.0.6.1.
  8. A

    DOA 4.0.6 & TOracleCommand.Execute

    Idea is very simple - I don't know intentionally or not, but result of TOracleCommnad.Execute method is meaningful for Non-SQL commands only. For SQL commands it is always false. I have checked with source code.
  9. A

    TOracleDataset descendant? Design advice needed!

    Don't know your exact needs, but usually it is a very bad idea (I even dare to say, design bug) to substitute sequence.nextval reference with custom function call as it: will very likely increase contention problems in multiuser environment a magnitude so really killing scalability [f times...
  10. A

    4.0.6.2.

    Hi, "registered" DOA page says that version 4.0.6.1 is available for download while it is 4.0.6.2 really. BTW, why not inform about new updates here? Yours sincerely, Oleksandr Alesinskyy
  11. A

    MessageTable

    Let me know how I can reference name of global package variable in the view, AFAIK you can only reference functions(standalone and packaged. Seems that Oracle DB shares my opinion: create package mumu as x number :=1; end; / select * from dual where mumu.x=1 ORA-06553: PLS-221: 'X' is not...
  12. A

    ORA-00904 Invalid Column Name

    In this case SQL withowt table definitions is absolutely useless.
  13. A

    PrivateDir

    It is very simple - there are no temporary files :p Except pagefile.sys, of course :cool:
  14. A

    Oracle 9.2.0.5 and views

    FYI, Oracle has recognized (on my insistence) this behaviour change of 9.2.0.5 as bug and has assigned bug number 3807954 to it. There is some hope that fix from Oracle will be available at late September.
  15. A

    OCI dll handle and Multithreading

    Sure, OCI DLL handle is a global variable in OracleCI unit.
See more
Back
Top