When I run next sql statement on Oracle 11g I got ora - 03113 but same statement run normal on oracle 10gr2
Is there a way to perform an ALTER SESSION SET time_zone=\'America/New_York\' within a stored procedure/package? I want to chan开发者_JAVA技巧ge the session TZ to NY then return it back to what it was
I am using oracle 11g and i have an application which is coded in Spring framework. Once i configure the database on Sun fire 4170 installed with Linux the machine\'s CPU utilization is around 80-100%
Hey friends i am using Oracle 11G. I wanted to generate reports for printing , SO i write this script
I\'am a asp.net web developer. I have the Oracle Client 11 instaled to test some features (EF support), but my applications must be in Oracle10 because my customer uses it.
Let\'s suppose I have a package A that has type type_bla is record (id number, ...); Also in the same package body I have a query, that fetches all the fields needed to construct the object. If I h
I have 11g installed locally on my machine (Windows 7 64bit). When I have disconnected all my clients from my oracle (ie no sqlplus running, no weblogic running) and then reconnect using sqlplus and
The command to enable versioning (part of开发者_C百科 what Oracle calls Workspace Management) in Oracle (DBMS_WM.EnableVersioning) creates non-materialized views, which cannot be indexed.Will this kil
I\'ve got a multi-threaded C application that was compiled using Oracle 10g (pro*c and libraries.) The program uses one database connection per thread. We\'re moving to 开发者_StackOverflow中文版11g a
We are getting the following error when using Oracle 11g ojdbc6.jar: WARNING: Error while registering Oracle JDBC Diagnosability MBean.