oracle10g

Source of sequence?

hi, I want to use source code of some sequences but i am unable to find it in ALL_SOURCE data dictionary. Please let me know where i can find source code for sequences used . ...

Problem with Hibernate template

Hello, I use hibernate for save, update and delete data in my database, but I have some problems. For example I have a request for save or update my data in database getHibernateTemplate().saveOrUpdate(client); getHibernateTemplate().flush(); When I launch my server (TomCat) for the first and I save my data, all is okay, in my data...

Oracle Variable substitute - Synonym

I want to substitute a variable in oracle. The var is coming in via SQLPlus and is reference using &1 &1 in my scenario is the schema name - here's the SQL. CREATE SYNONYM ACCOUNT FOR &1.ACCOUNT; Assuming &1 equals ABC the synonym created is for ABCAccount, instead of ABC.Account. For some reason the period is removed. Any ideas w...

Installing Oracle XE on Mac Leopard (issue with a segmentation fault)

I am trying to install Oracle XE 10.2 on my Mac Leopard. However, it doesn't go without a lot of fuzz. Thankfully I have this tutorial at my disposal: http://bit.ly/a4rc4O The only pain I am left with is the following command that fails (from the cfgtoollogs/configToolAllCommands). /Users/oracle/oracle/product/10.2.0/db_1/bin/netca /o...

How to run PL/SQL program in Oracle10g for Linux

BEGIN dbms_output.put_line('Welcome to PL/SQL'); END; / I have this code in sample.sql file. How to run sample.sql? ...

SQL 2005 - Table valued function compiles ok but throws Incorrect syntax near .. when selected

This table valued function compiles ok, alter function [dbo].[ftsls031nnnHades](@withExpiredEntries smallint ) returns @t table( comno varchar(3), t$cuno varchar(6), t$cpgs varchar(6), t$dile float, t$qanp float, t$stdt varchar(10), t$tdat varchar(10), ...

How can UNCLOSED connection be found in OC4J/Oracle ?

I fixed and use Connection Pool to get the DB Connection from JSP to Oracle Database now. But then I found out from the OC4J console at once that there are many UNCLOSED/NOT-CLOSED connection. I am using OC4J 9.0.4.1 and Oracle 10g. Is there any effective way to find out the location or area that the connection is not closed. In addit...

ASP - Oracle DB connection problem

dim sql set con = server.CreateObject ("adodb.connection") set rs_editorcolumn = server.CreateObject ("adodb.recordset") set rs = server.CreateObject ("adodb.recordset") mydsn =Application.Value ("dsn") con.Open (mydsn) This is my code.. It is working in another machine where it is deployed In my machine. ...

Oracle client runs into timeout

We are using an Oracle DB with different clients to view/edit the tables. It seems that the clients disconnect after a very short amount of time of inactivity (maybe 5 minutes). DreamCoder and Navicat Lite (our preferred Windows clients) both do not offer any option to solve this problem. When a timeout occurs I have to close the connec...

how to use exp command to export Oracle DB with files in different disk location

Hello, we get problem, while trying to export Oracle DB. OS: CentOS ~ 5.2 DB: Oracle 10g. Exp command exports db files only in location: /home/oracle/OraHome_1/oradata/master/xxx.dbf , but tool can't export files in different location (we know about this files after getting trace) like this: '/disk1/dblog06.dbf', '/home/di...

Oracle Transactions doesn't work as expected in some client machines in a .net windows application

Hi. I have an windows application in VB.NET (2.0) and Oracle Database, the connections are handled by System.Data.OracleClient. My oracle client is 10g. In the server side, the AutoCommit is off. The application uses transtactions (isolationLevel: ReadCommitted) for certain operations. The problem is that in some machines (and only in...

Oracle Oc4j 10i JNDI Datasource lookup problem

I am facing a JNDI Datasource lookup problem in Oracle OC4JAS 10i deployment. This problem occurs only in quartz scheduler job. any ideas? ...

How to remove a tuple from an SQL table after a timeout?

Hi, I am faced with a peculiar requirement which is as follows: A network-intensive operation is triggered to a server by multiple clients, through a web-interface. However, only one operation is allowed at a time, and hence an entry(tuple) is made in an SQL table to indicate that the operation is in progress. Once the operatio...

difference before and after trigger in oracle

Can somebody explain difference between "before" and "after" trigger in oracle 10g with an example ? ...

bulk upload and trigger

Few of questions for bulk-bind and trigger (Oracle 10g) 1) Will row level trigger execute in case of bulk binding ? 2) If yes then, is there any option to surpress the execution only for bulk binding ? 3) If no then, is there a way to execute row level trigger in bulk binding ? 4) Will performance hamper in case row level trigger execut...

Insert ...on duplicate in oracle?

Hi, I am new to Oracle and I want to check if particular primary key value is present or not. If value exists then just update the entire row .If value is not present, then insert new row. INSERT INTO table (a,b,c) VALUES (1,2,3) ON DUPLICATE KEY UPDATE c=c+1; Code above works on MySql. How to achieve the same in Oracle 10g? Can an...

How can you see what transaction isolation level an arbitrary oracle session is using.

I am trying to find out what isolation level a particular session (not my own) has on an oracle server. Is there a v$.. view to get this? ...

how to check status Concurrent Manager for APPDB from oracle using sql ?

Hello every one! I havent access to unix directories to execute shell script. Is there any opportunity to check status Concurrent Manager for APPDB from oracle just by quering it from table? Do we have another options to check it? for example I need get this information from table: oracle@gsmcrmtrain]/gsmcrmtrainindx02/or...

not able to drop a user in oracle

Hi, I am trying to drop a tablespace in oracle 10g , using my application . A bit about my application -- In my application I can create tablespaces. Now what happens in oracle is that when you create a tablespace , then a new user automatically gets created and is attached to the database. When you have to drop a tablespace what one...

Can I create an Oracle view that automatically checks for new monthly tables?

Hi! I'm wondering if its possible to create a view that automatically checks if there is a new monthly created table and if there is include that one? We have a new table created each month and each one ends with the number of the month, like table for January: table_1 table for February: table_2 etc... Is it possible to create a v...