Oracle Database Forum

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

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

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

Hi Greetings to all I am new to ProC. I am compiling a very simple program written in ProC. I can compile the program using proc filename.pc and it generates the corresponding c code :) , but when i try to compile the C program using cc -O3 -DPRECOMP -I. -I/opt/oracle/products/9.2.0/rdbms/public...

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

I've been trying to install Oracle 8.1.7 on a fresh Mandrake 9.1 O.S for days, but I'm still not able to get it running. I've tried several install instructions that I found on the internet but no luck yet. Here is a short description of what I did so far: 1. I installed the jdk118_v3-glibc-2.1.3.tar in the /usr/local/ dir and made a...

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

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

Hello everyone. I'm running Oracle 8.0 on NT4 (yep thats right) and running SQL*Plus 8.03. I'm typing the following at the SQL*Plus prompt: 1. Create Table EMPLOYEES 2. ( 3. FName VARCHAR(15) NOT NULL,

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.

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.

I want to know the column names that exists in more than one table; also, I want to know the table names where it exists. I tried this query and it took a long time and so I stopped it: select table_name,column_name, data_length, data_type from user_tab_cols where column_name in (select column_name from user_tab_cols group by column_name...

Hello, I was hoping to get some advice. I've been asked to set up a proof of concept type install of Oracle 9i and 9i A/S. Can I install A/S and 9i database server on one box or do I ~have~ to use 2 seperate boxes? Ford

has anyone ever created a query that you have a table which links into a one to many that has a one to many relationship with a lookup table and you want to return a single row with the data from the first table and the data from the one to many. example below of what i'm looking for, i would do it programatically but i'm using a generic...

Hello everyone. I am a newbie to Oracle 8 so please be patient and thanks for your time. The problem is the above mentioned error. I have two databases successully created using SQL*Plus 8.03. They are as follows: Create Table EMPLOYEES ( FName VARCHAR(15) NOT NULL, MINIT CHAR,

I'm writing a unique PL/SQL program to produce Oracle's AR's Invoices I'm not sure if TEXT_IO is a part of FORMS or PL/SQL ? It looks like PL/SQL but Oracle's Metalink indicates it is part of FORMS ? Also I couldnt find any samples with TEXT_IO & DBMS_OUTPUT in the same PL/SQL ? Can they be used together ?? Thanks in advance

Please I've captured an sql-statement form my db oracle ........FROM TN_PROJECT S ,TDM_LINKS L WHERE ((L.OBJECT_ID2 = :1) and (L.CLASS_ID2 = :2) what does means "= :n" ? thanks

I have a table with 100+ columns, for which I'm trying to retrieve only 1 specific record. For this single record, I do not know which of the columns are NULL, and which are populated. I would like to create a dynamically-generated SELECT--limiting the columns to only those that are populated. If, for example, only columns COL1, COL8, and...

Hi. Our company has about 20 application developers/architects and one certified dba. Our developers both design the databases and build the applications. We're confused about what permissions a developer is supposed to have. On the one hand, we obviously don't want developers to have privileges like shutting down the db. On the other hand,...

Hello All, We are currently looking into archiving our production system. I have looked into several different options to accomplish this, and Oracle Replication is one of them. Can anyone give me any info on Oracle Replication? We currently have Oracle 8i, and it comes with the GUI interface Replication Manager, which we would be...

Hi folks, I'm having a problem with initjvm.sql. I created a procedure to send a message using utl_smtp and when I run it, I got an error ORA-29540. I read that I needed to install JVM so I tried. The problem was that I got so many errors related with shared pool, declaration variables. Is there any configuration or change that I need to...

How can I get database SID in stored procedure in Oracle?

Hi everybody! My problem is as following: I have a trigger which fires on delete of a table row. The body of the trigger checks and manipulates entries in other tables. If the entries have certain values, I would like the row of the table which has fired the trigger not to be deleted. As far as I understood this problem could be solved...

I have a problem while connecting to a database (node) on my pc through the Oracle Management Server. The Oracle Management Server is on my system. However, when i try to connect to the specific database with the Enterprise Manager Console running as Standalone everything works fine. Where is the problem? Thanks in advance. --

I'm from a Sybase and Ms SQL server background and a bit new to Oracle. Does Oracle have a databse error log where all database errors are logged to? I've searched(maybe not hard enough) for either an overall oracle log and for an instance specific log, but have not found anything. Thx in advance