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...
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...
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...
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
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?
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...
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?
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...
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?
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...
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...
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.
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...
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...