Search results for query: *

Thanks Quehay, Writing a direct SQL statement workded for me. I am ignoring the stored procedures call until for a later research. Thanks for the help! Asfari

Hi, I have spent hours solving an ORACLE call to a stored procedure without avail. I tried to memic a code found on this website to connect to ORACLE and get back a value from a table through the otu parameter. My code is very similar to the code for allperson procedure call...

Hi, I have spent hours solving an ORACLE call to a stored procedure without avail. I tried to memic a code found on this website to connect to ORACLE and get back a value from a table through the otu parameter. My code is very similar to the code for allperson procedure call...

Thanks floks, I think all of the above are of great help. I will try looking into my Access DB relations, then if I still cannot update tables, I might have to combine ORACLE tables into on big Access table and follow blarson0's suggestion above.

Thanks for your input. But as mentioned by Mr. SBendBuckeye, I have to update ORACLE tables from one form. I have to have at least two = sign between two tables and I could not make that query updateable. Since the old Access daatbase use to have one table for most of the system, now it is been...

Hi, I am working with an exisitng system using many tables in ORACLE database. I am trying to keep our client MS-forms design not touched but have oracle tables (links) been accessed by forms. Doing so would require having existing Access form fields mapped to more than one ORACLE table...

Hi, I would appreciate the help, if someone can tell me how to access fields on one from from another one or from a module. i.e. I am lost here forms!MyForm. ...??? That is when to use ! and when to use . and on what objects. I am search VB help/Access with no avail. I have a form that has a...

Hi, I am working with an exisitng system using many tables in ORACLE database. I am trying to keep our client MS-forms design not touched but have oracle tables (links) been accessed by forms. Doing so would require having existing Access form fields mapped to more than one ORACLE table...

Hi, I want to et all of my 260 queries text that I designed in MS-Access. I can do this manually by visiting each query and viewing its SQL, but is there a better way, such as writing a query to ask Access system objects to spit out all of my queries text. I appreciate your hint hasfari

Thanks for the reply. You are right I am working on a client machine. I do not have access to the server but yet I am been asked to work as DBA! Here is a smaple script thatt I wrote and the feedback from SQLPLUS. I believe the UTL_FILE package is installed on my client machine and do not how...

Hi, I appreciate it very much if someone can tell me how to go around ORACLE spool restriction. I want to run a script that spools to a file using dbms_output.put_line function. However, spool has a limit and it stopped throwing text to the file after sometime. I checked ORACLE environment and...

I want to write a generic trigger and use it for some database tables in my database to create kind of transaction log record in the transaction log table. This trigger needs to be generic if possible and on the database level instead of one trigger for each database table. This trigger is a...