Oracle Database Forum

Hey folks, I have an user A connected to database DB. On NT this user is logged as B. So, I want to create a trigger to see when the user tries to connect the database, it checks to see if user connection and user logged on NT is the same. Do I have a variable that returns my user logged on NT ? My set variables has the user connect on...

I am trying to use RDB stored procedures to return result sets. How do I implement this in RDB? For example to select all employees in a table select * from employees How would I return a result set from a RDB stored procedure? Any help would be appreciated.

Hi I have one reports which shows the Account wise daily transaction during the day.(pl's find below report layout format with column description) May or may not be each account have multiple transaction during the day. My report break and compute as shown below.

Ik have created an index on a date field. 99% of all data in the table has a filled in date. 1 % is NULL When I do a select with clause ... WHERE ADATE IS NULL, Oracle does not use the index. Is this correct? or How can I force Oracle to use the index. Kind reagrds, Aad.

Dear all, I need some help. How do I full join two tables (with two columns each) together using the standard sql way on oracle 8? David -- Posted via http://dbforums.com

How does one track a user logon and the SQL that they execute?

Hi All, I have a table Truck_Journey with the following structure Tj_Date Date Tj_Truck_Id Number(5) Tj_Truck_No Varchar2(10) Tj_Km Number(9) ....

Hello, We have an apllication made with Designer 6 and everything works just fine. Using headstart too. Now a user has installed 6i and one form is crashing at the very beginning. On the testing mashine, installed 6i, patched with the latest version, still not working. All other forms and reports work just fine. This maybe isn't much info,...

I am running a 9.0.1 database on a W2K server and have come across some strange behaviour with a SQL query. I have a query which runs in a PL/SQL cursor which has several PL/SQL variables used to switch on and off certain rules. One idea I had was to have two queries UNIONed together with a simple switch selecting which half was to operate (I...

We upgraded a server from 512MB to 2.5GB due to performance issues. The server still uses ca. 512MB of physical memory. The total commit charge is 1.8GB. Physical Memory available is about 2GB. I've read about NT's 2GB/2GB problem, but I am not sure whether that is the cause. The main problem are most likely inefficient queries, but I...

Hi, When I click on "add database to tree" in Dba studio nothing happens, I can't see a list of instances to add to the tree and I can't manually type one in.... the menu option does nothing. This is a new installation of Oracle 8.1.6 on an NT system, running Dba studio V 2.1.0.1.0. I've been able to do this on other servers without any...

Assuming I have a db link that an application uses once in a great while. How can it be coded so that the link is close when not in use and only openned when it is needed? Thanks

Hi: I get the following exception from oracle. It seems to be happening during a rollback of a transaction, while doing an executeBatch() Has anyone seen this before ? Thanks much! -Prashant

I have a query which runs fine in SQL*Plus but which will not compile into a packaged procedure (claiming that the table can not be found): SELECT DISTINCT Folder_ID INTO l_RootID -- remove this line in SQL*Plus context FROM ifssys.ifs_folder_items WHERE Folder_Name = 'Root Folder' AND TYPE = 'FOLDER'; -> PL/SQL: ORA-00942:...

I have Oracle Apps ( AR & GL) and I working on creating our own Invoice but I'm unsure about certain aspects of PL/SQL & Printing. I have some PL/SQL working with the invoice data from AR_INVOICE_HEADER_V table already. 1. DBMS_OUTPUT vs. TEXT_IO What advantages exist for the two ? 2. Page breaking ??

I've been working with Oracle 9i for about 8 months on windows XP (the same problem occurs with WIN2000). However, I noticed that the latest release has some software that "hits the disk" about every 1-2 seconds! Anyway, this is a real problem on my laptop, because it can NEVER go into a low-battery-mode since the disk sub-system is always...

Hopefully just a quickie.. Which version of Red Hat Linux supports Oracle 9 DB? I just want to install it at home to get to grips with it, not run any mission critical apps with it, so i don't want to shell out $1500 for Advanced server if i can help it! Many thanks in advance. Andy Smith

Check-out this story on DBAZine: http://www.dbazine.com/burleson14.shtml I have end-users just like these. The illustration are hilarous!

Hello all, In my database I have a table with records. (Yes I have!!) Last week a record is changed, but I want to know on which date/time that was. Is there a oracle field in the table (like rownum) in which I can see the time which the recoird has changed?? (please do not answer with the sollution to add an extra "field" in the table...

Hello all, I've got what appears to be a bug in Oracle, but I don't want to make that judgement until I get someone's opinion who knows Oracle better than I. I'm running Oracle 8i on Solaris 7. I have a query that I get different result sets with and without a specific index. This is repeatable with these tables, though I haven't been...

Hi All, I have a table Truck_Journey with the following structure Tj_Date Date Tj_Truck_Id Number(5) Tj_Truck_No Varchar2(10) Tj_Km Number(9) ....

Has anyone experience with Adonis Maritime Software (http://www.adonis.no) on the Oracle platform? The website does not reveal much information on the application/database setup and workwise. Regards, Berry

Hi I have a full exportfile xx.dmp from my 8.1.5 database and I want to upgrade to version 9i using Enterprice manager. How shall I do? I dont want to use the upgrade utility beacause I am doing a clean installation of 9i on a new computer. Regards Roger

How can I make datebase link on datebase link? On instance B there are datebase link on instance C. How can I make db link in instance A on instance C over db link on instance B. I have to make it on Oracale 8i. -- With regards, ilica _________

Hi all: I have an oracle 9i server running behind a firewall. i set up the machine that has the oracle server as a DMZ zone. i can connect to the oracle server from the local network but not from outside (using the oracle THIN driver) can anyone tell me what is the problem and how to solve it? thanks