Search results for query: *

PolicyPremium and Max_Archive are tables within the Oracle database but the tables these are being populated from are in Access, i.e. DPOLICY, CobeType, StatusCodes for Policy Premium and Max for Max_Archive. So how do I speed up the append taking this inot account, will stored procedures still...

Robbie, Thanks for the details on creating the stored procedure but my question now is how does one call this from Access. Also as the tables I am appending from are in Access how does the Oracle procedure read from these tables in order to do the append. Another thing is that the two queries...

Yes, both tables are contained in the same Oracle database within the same tablespace. I have no experience really with Oracle, how do you create the stored procedures and how do you call them? How do they link to the Access tables, since this is where they have to get the data from in order...

The two tables involved are stored in Oracle now and linked by ODBC, Oracle ODBC Driver version 8.00.06.00. I have also tried writing code using OO4O to do the append but can't seem to get it to work, it seems to be doing the append without any errors but just hangs and even after being left...

There is a Primary Key of Year_no, Week_no and Policy_no on both tables. Then each has an index on Policy_no also.

I have migrated (using OMWB) some of the tables from an Access 97 application to Oracle 8i and am now trying to get it to run quicker. The application when completely in A97 took between 30 and 40 minutes to run, now with two of the larger tables in Oracle it is taking 160 to 200 minutes. This...

The error definitely seems to be arising from the date being added in the last column of the insert. The value from rsDetails.ComDate is formatted as text so don't see why it's not working, the solutions I've found on the net say the problem arises because the date is being added in number...

Meant to put in that I'm using Access 97 and Oracle 8i

I am trying to insert the results of an Access DAO recordset into an Oracle table through OO4O. The code is detailed below, from which I keep getting the error SQL execution error, ORA-00984: column not allowed here I have checked for solutions on the net and all seem to point towards a...

I want to delete records for the run year/week from tables which have been migrated to Oracle from A97. What is the best way to do this? The current queries that worked while tables were in Access are now giving 'not an operable query' errors. An example of the query involved: DELETE...

Essentially what I need is to be able to delete records from an Oracle table using A97. I know that it must be something simple but I just don't seem to be getting anywhere. I need to run a delete query on a table and then an append query to append the records for the run week. Each week...

I'm setting up a number of A97 applications to allow users to view reports, most of them being set up in Landscape with some in Portrait. The problem I'm having is that when the users connect over Citrix and view reports, all reports are formatted as being Portrait so the Landscape ones no...