Recent content by bchau

  1. B

    Oracle Database Version

    Hi, Is there a function to find out either you are running in Oracle 7.* or Oracle 8.* from TOracleSession? Thanks, Bryan
  2. B

    Component package problem when upgrade to DOA 3.4.2 for Delphi 5

    Marco, Why can't you keep the same name as doa.bpl? Bryan
  3. B

    Component package problem when upgrade to DOA 3.4.2 for Delphi 5

    Hi, I have created a component package using the older version of DOA 3.3.1. Once I upgrade to DOA 3.4.2, my component package doesn't work any more because it's looking for the dependency file call doa.bpl; but the newest file name is doa34d5.bpl. Does this mean that I have to re-compile my...
  4. B

    Cursor variables

    Sandy, I'm not sure I'm understand your question. You question is 'How can I CLOSE open cursors?', but where do you want to close the cursors in the store procedure package or in delphi code? Why do you have to close the cursors?
  5. B

    How can I retrieve the value of variables in a store procedure?

    I think the second GetParameter should be (9) instead of (1). EmailItem.MailID := StoreProcedure.GetParameter(0); EmailItem.JournalCode := StoreProcedure.GetParameter(9);
  6. B

    Oracle 8 question

    Hi Marco, Thanks for the information, but I've done a few application with Exe calling Dll. Is there any solution or way to get around to share on OracleSession with multiple Exe?
  7. B

    Access Violation Error Message

    Hi, I have a host-program(executable) connect to Oracle database calling a Dll and sharing the same OracleSession.ExternalLDA. Everything work fine, I close the Dll, everything is still Ok, but when I close the host-program, I always get the 'Access Violation' or 'Priveledge Instruction'. Can...
  8. B

    Sharing TOracleSession

    Thanks, I've done a lot of Exe calling Dll application and share the same TOracleSession. But what I need to figure out is how to share the same TOracleSession with other Exe1, Exe2, Exe(s). The issue is I want to be able to share one TOracleSession in the main.Exe with other multiple Exe...
  9. B

    Oracle 8 question

    I would like to, but the company database is upgrading from Oracle 7.x to Oracle 8, that's why I need to modified my code to use the OCI8. I read in DOA's version 3.33, the TOracleSession has properties call "Share" and ExternalSVC, etc..., does this work like ExternalLDA in OCI7? If yes, can...
  10. B

    Oracle 8 question

    I read some where that Oracle 8 doesn't support the ExteralLDA pointer anymore, is this true? In Oracle 8, is the ExternalSVC is a replacement for the ExternalLDA in Oracle 7.x. If it's true, then How am I go about using it between an Exe and a Dll?
  11. B

    Share one TOracleSession between Multiple EXEs

    Can you send me an example how to approach it because I stuck in the same situation try to share one oraclesession with multiple Delphi exe under WinNT 4.0. My email address: bchau@rocketmail.com Thanks
  12. B

    Help Insert into a Grid

    Try this, Set the CachedUpdates property to false. or you may need to leave the current inserted or updated record(by clicking on a different row) in order for the post to take place.
  13. B

    Sharing TOracleSession

    Hi, I use the TOracleSession component in my Main.exe to connect to Oracle's Database. The issue I have is I want other executable files(3 or more) to share the same TOracleSession. I try Memory Mapping File & TMemoryStream method, Store the component in the Dll, and so far I have no luck...
Back
Top