Is it possible to execute stored procedure through a Linked server
Is it posible to execute Oracle 10g stored procedure on a sql 2005 Linked Server. ...
oracle10g
how to store BigInteger values in oracle database.
I have connected Java program to Oracle database using JDBC. I want to store BigInteger values(512 bits) in the database. What should be the type of the column? I m trying like this: I have taken a column of number type in the database. I converted BigInteger to BigDecimal like this: BigInteger b=new BigInteger("577985757095780257907...
Why is an oracle sequence named hibernate_sequence being created with JPA using Hibernate with the Oracle 10g dialect?
All my entities use this type of @Id @Id @GeneratedValue(strategy = GenerationType.SEQUENCE, generator = "MYENTITY_SEQ") @SequenceGenerator(name = "MYENTITY_SEQ", sequenceName = "MYENTITY_SEQ") @Column(name = "MYENTITY", nullable = false) private Long id; Or @Id @Column(name = "MYENTITY") I find that an oracle sequence named hibern...
APplication performance issue : SqlServer & Oracle
Hi, We have a applicaiton in Silverlight,WCF, NHibernate. Currently it is supporting SQL Serve and Oracle database. As it's huge data, it is running ok on SQL Sevrer. But on Oracle it is running very slow. For one functionality it takes 5 Sec to execute on SQL Server and 30 Sec on Oracle. I am not able to figure out what will be issue...
Oracle grant concession and side effects
Working every day on a large Oracle production database (10g), we noticed that operations like granting an user read privileges on a table creating a trigger on a table lock that table, and invalidate all the cursors insisting on it. This has tremendous consequences if the table is big (> 20 million rows) and many users are working ...
SQL running slow when i executes thru java
I am trying to execute a query in oracle db. When i try to run thru SQLTools the query is executing in 2 seconds and when i run the same query thru JAVA it is exectuting in more than a minute. I am using a hint /*+ordered use_nl (a, b)*/ I am using ojdbc6.jar Is it because of any JARS? Please help whats causing this? ...
Oracle Driver Installation
I am having Oracle 10g installed on my laptop and have downloaded ojdbc14.jar driver for the same. The problem is, my operating system is Windows 7, and I'm not having option to create a Data Source for Oracle since I m not having oracles driver installed. I m having option to create a Data Source for SQL server 6, but I want to get conn...
How to query multiple columns into more columns in oracle 10g
Hi Stackoverflow, This is possibly answered somewhere already but had trouble searching for it as I think I'm missing key terms. What I want to do is convert multiple columns into more columns so my query currently returns this: col1 | col2 | col3 __________________________ a | x | 1 b | y | 1 c ...
Error on installation of Oracle Database 10g on Windows XP (SP3)
I am trying to install Oracle Database 10g on Windows XP SP3 (It is a VM on Mac OS X). After the first screen in installation program, it gives an error "The value for SID may contain only ... Is there any hint ? ...
Conflict on ORACLE_HOME: OC4J + Oracle Database 10g (10.2.0) on Windows XP
My project requires me to use OC4J and Oracle Database system. Therefore, I go to Oracle web page to download OC4J Application Server (oc4j_extended_101350) and Oracle Database 10g. Installation of OC4J is simple. I just unzip it to a folder and set the JAVA_HOME and ORACLE_HOME. Then everything is fine. But then, Oracle Database canno...
SQL*Plus 8.0600 crashes at the trial of connect to Oracle 10g (10.2040)
Background: Oracle Forms - DB migration; 6i to 10g Hi everyone! Customer situation: We want to attemp a DB connection with SQL*Plus 8 to a Oracle 10g DB (standard installation). Unfortunately SQL*Plus always crashes without any error message. We tried the same scenario with our systems - there was no problem. Now we are confused. W...
Oracle Express dropping connections with 2 users
We are using Oracle Express as our development DB. When 2 programmers try to connect to it via jdbc we get dropped connections. Is this a limitation or Oracle Express edition? If we have 2 separate logins we still have this issue. ...
When does a role get enabled for a user in Oracle 10g?
I use ADO.NET from C# 4 in order to set up a test context for a component. I execute the following SQL as sysdba: new[] { "create user \"{0}\" identified externally default tablespace USER_DATA temporary tablespace TEMP profile DEFAULT" .FormatWith( Config.QualifiedUserName ), "create role {0}" .FormatWith( Config.RoleN...
Variables in PL/SQL
I am working on a rather large SQL script to be used with Oracle, but I'm running into an issue. First, let me outline how the script operates. Declare variables`CUSTOMERID NUMBER;``SERVERID NUMBER;` Create a customer if it doesn't exist `SELECT ID INTO CUSTOMERID FROM CUSTOMER WHERE NAME = 'The Customer I just Inserted';` Create the s...
How to add time value to a new Row?
How can I add to a field in a Table built in Oracle database a time? ex: I want to add the value 13:00:00 to the field Time in a table named Data How can this be done? I`m using Oracle 10g Express Edition ...
Error FRM-30113
I use Oracle Form Builder 6i. Suddenly I receive 3 errors that I can't handle: Error Frm-30113: block must have non-query-only database item.block capa_problems. FRM-30362 Initialize value does not match available list elements. list v_impact_proc_area Item : v_impact_proc_area Block : search_block Form: problem_review_app...
Data Source For Oracle
I am using 64-bit version of windows 7. The only option I have in it, for creating Data SOurce is for Microsoft SQL server 2005. Hence, I am not in position to create ODBC for oracle. Is there any other way by which I can create the ODBC Data Source. I need the same for JDBC. Thank You. ...
Parsing XML in an Oracle function
I have a very simple XML document that is stored as a VARCHAR2 in an Oracle 10g table. Below is an example of the XML. I want to take the XML and insert it into a global temp table as a single record. I've seen a couple other questions related to this topic but they were a little mor complex than I need. Anyone show me how to grab th...
Deploying ASP.NET application which access oracle database ?
I have just developed .net application using visual studio 2008 on windows 7 which accesses remote oracle database *10g* using ODAC ODTwithODAC1020221.exe and Oracle 10g express edition as it automatically installs oracle client. I do not certainly know what else is installed on my development computer but on I could connect to oracle da...
oracle rman simple backup
Hi I would like to backup an Oracle 10G as simple as possible. It is in NOARCHIVELOG mode and I can shut down for backup (it is only a development server). After reading tons of documentation abour rman I tried this way in rman: shutdown immediate; startup mount backup database; sql 'alter database open'; As I see it works fine, lis...