We use MSDAORA to connect SQL Server 2000 with Oracle 8.06.20 using linked
server through Oracle Client 8.1.7. It works fine with simple SELECT statements. However as soon as we placed a WHER...
Running Informatica (V ) over Oracle database on Unix Server.
Is there a way we can automate (read Batch job) the folder copies from Dev Repository to Prod Repository. Drag and Drop is OK,...
Issues connecting from Mercury Test Director software to oracle. Opened a call with Mercury but thought someone else might have
seen these errors, which are below. Windows 2000; Oracle 92. ...
I have a webserver running IIS inside a firewall. I have a db server running Oracle 9.2 inside the same firewalled network. IIS is set to windows authentication mode to secure it. I have a hol...
Have installed Windows 2000 Server. and ORacle 8.1.7 Edition.
After installation the Database was working fine. but once i restart the PC, not able to connect. checking the status found that ...
When I have a dial up connection to the internet and I disconnect while I am running TOAD, I am disconnected from the Oracle connection.
What is the cause of this behaviour?
Does OO4O (Oracle Objects for OLE) work for Access2000? Where can I find
some code examples/books/tutorials if this is possible?
Thanks!
Hi there,
I have a stored database packaged procedure which includes references to a remote database via. database links.
e.g. select customer_id from c_customers@LIV
where ........
...
I have recently started using RMAN for database backup. It is Oracle 9i on Unix OS. Per the Oracle manuals and documents, I should be able to query the RC_DATABASE,, RC_DATAFILE, RC_ARCHIVED_L...
hi,
i'm new to oracle forms and i want to implement OCC instead of the standard pessimistic lock.
e.g. i have a GUI for an update-operation and i have a PL/SQL-procedure, that manages the wh...
Would be great if anyone could help me with this:
Say I have two forms A and B, A has a repeating timer
which, when fires, will GO_FORM to B and B's WHEN-WINDOW-
ACTIVATED should fire and d...
I am looking for some very simple query tool for oracle database.
I want to install the tool in my windows machine. It can connect to an oracle database, and let me access the values inside...
Hello, I came back with my question about hierarchical tree.
htree := Find_item('MyTree');
new_node := Ftree.Add_tree_node(htree,
Ftree.root_node, Ftree.p...
We have the following tables
Desc Purchase_master
Name
---------------
PNO (PK)
PDATE ==> we need in this question
ITEM
BRAND ...
I want to allow modifications to a certain key field in another block only on condition that the record in another block is a new record that so far has not been saved. How do I test if this ...
hai everyday when i began oracle its giving ORA-01034 error, i am typing svrmgrl and and some commonds in dos prompt then its coming, everytime i log off system, the same error is occuring,...
I have to do a report with a special format, i'm not an expert with Oracle Reports 6i, so I ask for help desperately!!! The report uses the following tables:
COMP
idcompc varchar2(20), ...
I HAVE A SERVER ON WHICH IS INSTALLED ORACLE_10G.I WANT TO ACCESS A ORACLE 8.1 DATABASE, IN ORDER TO ACHIEVE THIS I HAVE MODIFIED THE THE TNSNAMES.ORA AS FOLLOWING
ALIX.WORLD =
(DESCRIPTIO...
i created the button in my form9i for loaddata
and created trigger when-button-press my code is
begin
host ('cmd');
end;
it call command.
c:\
i key word like this
c:\sqlldr...
I want to have the user select an emp no to narrow their selection,
if they want. This works fine if they enter an emp no.
However, if they dont enter anything they should get everything i...
I need to create a before trigger that looks at a table to see if a row exists if it does exists then it needs to check a field to see if the field is a valid code.
If a valid code is foun...
I am a developer who is working out an automated feed from our companies employee database. They use PeopleSoft and I've been told that they can only export an Excel file. Given the wide use o...
I'm working in orgnization which ask for many reports and alot of statistical reports so always I type the SQL script and run in Toad software. I reach the point that I'm doing very big number...
I would like to extract the performance graphs in the Oracle Enterprise manager, and the OID web interface to flat files to display them on an external system, I would be pleased to know how f...
Hi
plate form : windows environment. and 9ias 8i database which is installed another system.
I have a report in Reports 6i, which was working in iAS with Oracle 8i database successfu...
