Recent content by RANDY_AT_TRADEWINDS

  1. R

    ORA-12545 When running an application from a remote server

    We have a windows 10 machine that retrieves our application from a remote server, connects to the database and runs it. In the last couple of weeks, only one node on the network started failing. There are 5 nodes, and all except this one has no problem. We get the ora-12545. So, from the...
  2. R

    Entry Point Not Found when trying to access doa34d5.bpl

    I'm using Oracle 8i personal with version 8.1.7.0.0 of the oci.dll. I've created a package that requires the doa34d5.bpl. It links ok, but when I try to load the package I get the following error message. "The procedure entry point @Oraclewwdata@initialization$qqrv could not be located in the...
  3. R

    ApplyUpdates: Datasets must belong to this Session

    Nope. The session called was the same. The datamodule that holds the session is named dmposting. The session on that datamodule is ses_posting. Both of the datasets on my main form show dmposting.ses_posting as their session. The name of the master datasource is q_master. The name of the...
  4. R

    ApplyUpdates: Datasets must belong to this Session

    No, that's what it sounded like, but I made sure they were. The session doesn't reside on the same form as the 2 datasets, but they are both pointing to it. The only other thing that I could see was that cached updates was not turned on on the master. Just the detail. Thanks
  5. R

    ApplyUpdates: Datasets must belong to this Session

    I have 2 datasets. I is the master and one the detail. I do not need to update the master. Cached updates is true on the detail only. Is that why I'm getting this message?
  6. R

    Creating scripts to update remote databases

    First let me say that I've been using sql worksheet and text files to compile pl/sql objects before now. I LOVE pl/sql developer! This has saved me alot of time and is a good tool. Currently I keep several sql scripts for a database. One that lists all the tables, indexes and constraints and...
  7. R

    refresh issues with doa

    I know it's puzzling. Oh well, as long as it works. With the BDE the database was committed when you closed the component. With DOA does it work the same or should I issue a commit at the toraclesession level?
  8. R

    LIMITING TABLES AVAILABLE TO USERS

    I would like to include the query reporter in my application. Can I purchase a copy of the source code? I need to limit the tables available to users. Also your license doesn't allow re-distribution. If the answer is no, do you know of another tool as good that does allow re-distribution...
  9. R

    refresh issues with doa

    Why would simply moving the toracledataset to another datamodule fix it? That is all I did. I'm puzzled. Are you saying that when I commit a transaction one one dataset or query I should issue a refresh on another, even though they are both connected to the same session?
  10. R

    refresh issues with doa

    Ok, after fighting this all weekend I finally figured out something. In this situation I had procedures on one delphi form that called procedures on another delphi form which in turn called procedures on yet another. The third form held my toraclesession and all the toracledatasets and...
  11. R

    refresh issues with doa

    I'm converting a very large application from bde to doa. I don't use cached updates. I'm finding that doa components don't seem to work the same as bde when it comes to updating the database. For instance I'm creating a master/detail record in the database using a stored procedure. The...
  12. R

    Initialization Error when loading app from network

    It's fixed. There was a piece of the application that was still connected to Oracle via the BDE. It was the first piece the app used when launched (i.e. the application connected using the BDE first). Once I converted it, everything worked fine.
  13. R

    Initialization Error when loading app from network

    I'm converting an application from BDE to DOA. I'm using Delphi 3 and Oracle 7.3.4. I'm converting the application on a local machine and when I run it from the local machine, everything works fine however, if I copy the application to my server and run it from there (but still using the local...
  14. R

    ORA-01036 Illegal Variable Name/number when calling stored procedure

    I'm using Oracle 7.3.4 and am using the toraclequery to call a stored procedure. The stored procedure has 4 variables... IN_CONTRACT_ID, IN_CROP_YEAR, IN_WAREHOUSE_ID and IN_WAREHOUSE_REC_PSR. I'm calling it like this; with sp_record_rice_inventory_cont do begin...
Back
Top