oracle11g

Getting location of file tnsnames.ora by code

How can I get the location of the tnsnames.ora file by code, in a machine with the Oracle client installed? Is there a windows registry key indicating the location of this file? ...

Is it possible to create an Oracle 11g database using an Oracle 10g ASM instance?

Is it possible to create an Oracle 11g database using an Oracle 10g ASM instance? ...

Oracle - Need help with RMAN Active Duplication on Windows 32 bit to a 64 bit

I need to have an Oracle 11g R1 on a Windows 32-bit duplicated to a Windows 64-bit using RMAN Active Duplication. 32-bit setup: Windows Server 2003 R2 Standard Ed. SP2 Database - Oracle 11g 11.1.0.6.0 64-bit setup: Windows Server 2008 R2 Standard Ed. Startup Database - Oracle 11g 11.1.0.7.0 Although 11g R1 is not cert...

crystal-report problem + Oracle

hi i have build C# program that connect to Oracle and make some report's using crystal-report. in my computer it work's excelent (when i bind to my Oracle) but when i run my program on other computer - the program work and i see the data on the screen, but when i try to see report with crystal report i get error (problem with connection ...

If I drop a table and the table doesn't exist, I get an error.

Hi, I need to drop a table and make a new one. If I drop the table and the table doesn't exist, I get an error How can I check if the table exists? I'm working on Oracle 11g Thanks in advance. ...

Table-Valued Functions in ORACLE 11g ? ( parameterized views )

Hi all, I've seen discussions about this in the past, such as here. But I'm wondering if somewhere along the line, maybe 10g or 11g (we are using 11g), ORACLE has introduced any better support for "parameterized views", without needing to litter the database with all sorts of user-defined types and/or cursor definitions or sys_context va...

C# ASP.NET Syntax to Call Oracle Stored Procedure

How from ASP.NET I can call a stored procedure in an Oracle package that accepts a VArray. The VArray will pass a list of keys that the stored procedure will use to modify appropriate records. I know I could send the keys in separate calls or send a delimited list, but I'd rather use an array. ...

Switching users on a JDBC Connection

I am writing a Java JDBC database application that connects to an Oracle 11g database and am using a c3p0 connection pool. For the purposes of an example, I have 3 database users DEFAULT, TOM, and BILL. c3p0 opens all of the pooled Connections with the DEFAULT database user. I would like to retrieve one of the pooled Connections from c3p...

WSRP Portlets in Oracle WebCenter : Images referenced from CSS files aren't loaded

If a WSRP portlet displays a jsp page that references a css file which references an image, the image can't be loaded because the url in the css can't be found. The url in the css is a relative one: ../images/image.gif. Details of my problem I have developed a JSR168 portlet (Java Portlet Standard) and I want to deploy it in Oracle Web...

Exception when deploying a JSR 286 portlet into WebLogic+WebCenter 11g

I get the following exception when deploying a JSR 286 portlet into Oracle WebLogic Server 11g (to deploy it later in Oracle WebCenter 11g): <19-ene-2010 13H32' CET> <Error> <oracle.portlet.server.containerimpl.PortletApplicationImpl> <BEA-000000> <Error al procesar el archivo "/WEB-INF/portlet.xml" en la lÝnea 6 columna 68. org.xml.sax...

Generating UUids in a web farm environment

Hello All I am planning on using sequential guids as primary keys/uuids as detailed in the post below http://stackoverflow.com/questions/170346/what-are-the-performance-improvement-of-sequential-guid-over-standard-guid/170363#170363 I am wondering if there are any gotchas as far as generating these guids across multiple web servers in...

Can we use Oracle Developer Tools 11g with Visual Source Safe ?

Is it possible that i can check-in/out my Oracle database Packages using Oracle Developer Tools 11g for visual studio ? ...

what is the most lightweight oracle version ?

hi i want to install oracle 11g on a very weak computer for learning. what is the most lightweight oracle version ? is it the express edition ? thanks in advance ...

How to select results between two dates or by single year/month/day in oracle? (to_date, extract,sysdate)

I have a table for orders and it has 2 column with DATE types: delivery_date and order_date. In my sqldeveloper, all the dates I've inserted via Java or by hand are in the format 10.01.25 for the 25th Jan of this year. When I try to see the the total_price for orders between one date and another, I force the format like this: create...

Format Describe In SQL*Plus

I like a large linesize in SQL*Plus so that data doesn't wrap between lines. The problem is that doing a describe on an object seems to be obligated to spread itself over the entire line size. This makes it so that I can only see the name part without scrolling to the right. What I want is one linesize for describes and a different li...

PL/SQL varchar(10) to varchar(9)

How would I write a loop that has a select in the “in” clause of the loop that selects a col of type varchar(10), but then inserts those values in a col that wants them to be varchar(9)? Basically I’m trying to “typecast” from one precision to another, if that makes any sense. Example: FOR V_TEN IN (SELECT THIS_IS_VARCHAR_TEN FROM TABLE...

Is it possible to store '' (empty string) as a non NULL value in the database?

I am using Oracle DB. At the database level, when you set a column value to either NULL or '' (empty string), the fetched value is NULL in both cases. Is it possible to store '' (empty string) as a non NULL value in the database? I execute this UPDATE contacts SET last_name = '' WHERE id = '1001'; commit; SELECT last_name, ID FROM c...

.net Oracle Data Provider transaction rollback not working

So this is the problem. I need to insert into tableA and get its new row id. After that, I must insert that id into tableB. I must commit after the insert into tableA so that when I attempt to insert into tableB I won't get a foreign key exception. Now, my understanding was that if an exception was raised in the function that inserts...

ExecuteNonQuery() returns -1 in Update when records are updated

I've verified that my method/Oracle procedure is working correctly, but in my C# I always get -1 returned from ExecuteNonQuery(). Consequently, the below bool is always false. We only use Triggers in our DB (Oracle) for INSERT statements. Do I need a trigger for an update statement? Any suggestions why that would happen? Its defin...

Oracle 11g VARRAY of OBJECTS

I have the following statements in Oracle 11g: CREATE TYPE person AS OBJECT ( name VARCHAR2(10), age NUMBER ); CREATE TYPE person_varray AS VARRAY(5) OF person; CREATE TABLE people ( somePeople person_varray ) How can i select the name value for a person i.e. SELECT somePeople(person(name)) FROM people Thanks ...