Version Of PL Engine?

Aug 28, 2008

How to know the version of PL/SQL Engine

View 1 Replies


ADVERTISEMENT

Precompilers, OCI & OCCI :: PRO*C Compiler Version Versus Database Version

Oct 15, 2010

We are planning to upgrade a database from 9.2.0.8.0 to 10.2.0.4.0.We have a lot a PRO*C programs pre compiled using 9.2.0.8.0 (and most likely even 9.2.0.7.0) compiler.

if we could upgrade the database without having to re-compile all the programs.We have tested this approach against some of our programs. Most of them executed fine - but in 2 cases we are getting "ORA-01001 invalid cursor". I suspect, that the case is that Pre compiler version 9 is not supported against 10g databases - but I am not sure.

Would it be a better option to upgrade Pre compiler/client as the first step and the db as the second step (and would that be supported) ? We definitely don't want to upgrade both Pre compiler/Client and the Database in one goal - that would be too risky.

View 3 Replies View Related

Oracle Database Alert Engine

Mar 15, 2011

I am running Oracle XE . This database collects information about server statistics in my organization ( memory usage, threads running, etc). Now , I need to send alert/ notification emails if the certain thresholds are crossed by server ( ex: if number of threads increase more than 100, send an alert email).

One way to do this is to write stored procedures and schedule them to run every hour and send alert email if conditions are met.

But what I want to do is to use some sort of rule engine where I can specify the rules/conditions which have to be true for alerts to be sent. The reason I want this approach is so that every time there is a new rule, I do not have to write a new stored procedure and I can just specify the condition in the rule engine . So are there any Rule Engines out there that I can use (preferably open source and free to use)?

View 2 Replies View Related

Forms :: Report Engine Is Not Running

Jul 22, 2010

I am facing a problem while calling a report from FORM.the system gets hang and RWRBE60.EXE is not started.I am using client/server environment and Form 6i.

View 2 Replies View Related

Reports & Discoverer :: How To Run Version 10g Report In Builder 6i Version

Jun 3, 2010

I have a report of version 10g . I want to run this report in oracle reports 6i version.

View 1 Replies View Related

Reports & Discoverer :: Oracle Report Engine Error

Jul 4, 2013

I m trying to run reports from my application developed using Oracle FORMS6i but the report engine does not show any job. Platform Information: Microsoft Windows Server 2012 Version 6.2 (64 bit).

View 2 Replies View Related

Forms :: Reports Background Engine Stopped Working

Jun 28, 2011

When i run my reports on Windows 7 i receive the following error Reports Background engine Stopped working

When i view the detail of the error it shows

Problem Event Name APPCRASH
Application name RWRBE60.EXE
Application Version 3.0.0.0
Application Timestamp 38a27e49
Fault Module Name rwlib60.dll
Fault Module Version 0.0.0.0

I think it is sufficient information for you experts to resolve this issue reports are designed in developer 6i please view the attached image for report error detail.

View 8 Replies View Related

Application Express :: Views In 4.1.1 Is Crashing Apex Engine

Dec 11, 2012

I have over 27 views in apex and made a column name change in the views and after I compile about 4 or 5 of them, the apex engine crashes. I was compiling the data views first, before moving on to report views. When I upload the views and ran them in the as a script, it said all of the views were created.When I went into object browser most of the views compiled. I recompiled the ones that were marked red. I compiled them in the code window, incase it threw an error, I can fix it there.

I had problems with views, before causing core dumps when I compiled them, but figured I had to compile the views in a certain order.

View 6 Replies View Related

SQL & PL/SQL :: Check If A Particular Version Available In Earlier Version Of Oracle

Mar 30, 2012

I am using Oracle 11g version, I wanted to check if a particular function is available in the earlier version of Oracle (Say 9i). Oracle optimizer to run the query only using the features available in the 9i version?

View 4 Replies View Related

Application Express :: Error When Refreshing Report Region / ORA-20876 - Stop APEX Engine

Mar 26, 2013

I'm using Apex 4.2. On click of a button, I refresh 2 Standard Region Reports with a Dynamic Action. This dynamic action has been working without problems for WEEKS and all of a sudden i'm getting the ORA-20876: Stop APEX Engine error when I click the button.

In the dynamic action, I removed the refresh of the second report and now the error does not occur. If I add the second refresh action back in, it throws the above error. I've even tried making the second report identical to the first and the refresh action fails. why this is failing on the second refresh action since the second report & region is IDENTICAL to the first report now.

View 3 Replies View Related

Exp 10.2.0 To Imp 11.2.0 Version Database?

Aug 15, 2013

I have doubts on export

1.) If we have taken exp (traditional export)of schema�s on database version 10.2.0 then shall we imp(traditional export) on database version 11.2.0?

2.) If we have taken expdp of schema�s on database version 10.2.0 then shall we impdp on database version 11.2.0?

3.) If we have taken exp(traditional export) of schema�s on database version 10.2.0 then shall we impdp on database version 11.2.0?

View 6 Replies View Related

SQL & PL/SQL :: How To Know Uses Of Oracle 9i Version

May 31, 2010

How to know the uses to oracl9i version ?

View 2 Replies View Related

XE :: Download And Use Version For Mac Using OS X 10.4.11

Jun 14, 2012

Can I download & use a version for a Mac using OS X 10.4.11?

View 1 Replies View Related

ODP.NET :: Upgrading From Version 10 To 11

Jun 6, 2013

We have several applications hosted on a server using ODP.NET 10, but we are the first to decide to upgrade to ODP.NET 11 which means we need a method where only our application uses ODP.NET 11 without affecting any other existing applications.

I've read about the policy files which automatically redirects application to use latest version installed on the machine. Is there a method available which can avoid this situation as the owners of other application may not allow this to happen.

How can I ensure that my application is using ODP.NET 11 or ODP.NET 10 if both are installed? I created two sample app one with Oracle.DataAccess.dll 10.2.0.100 and other one with Oracle.DataAccess.dll 2.112.3.0. With below line of code, I found both applications are showing Oracle.DataAccess 2.112.3.0 at runtime.

System.Data.Common.DbProviderFactories.GetFactoryClasses();

Last thing, I may be wrong saying latest ODP.NET wouldn't work with NHibernate 1.0.3.0. please validate.

View 4 Replies View Related

Difference Between Oracle Version 10.2.0.3 And 10.2.03?

May 28, 2008

difference between oracle version 10.2.0.3 and 10.2.03.I searched a lots of sites to get the details about these versions but unable to collect.

Oracle released both version or 10.2.0.3 and 10.2.03 are same versions treated by oracle.

View 2 Replies View Related

Select Row With Highest Version

Aug 25, 2010

My table holds info on documents:

|doc_id|auth|version|date_created|

so what I'm trying to do is select the latest version of each document record.

so say I have there records:

doc_uid|doc_id|auth|version|date_created|
|1 | 100 |al |0.1 |11/4/08 |
|1 | 101 |al |0.2 |11/4/08 |
|2 | 102 |al |0.4 |11/4/08 |

So i want to select only one copy of every doc_uid(unique id) with the highest version number, which would make my output:

doc_uid|doc_id|auth|version|date_created|
|1 | 101 |al |0.2 |11/4/08 |
|2 | 102 |al |0.4 |11/4/08 |

doc_id 100 was excluded because it has a higher version which was shown instead.

So how would i express this is oracle sql.

edit: Just thought i should say that I have been tring to crack this for 2 days now :P I have been messing around with MAX() but I cant make it do what i want.

View 6 Replies View Related

Forms :: 10g Version Control

Mar 17, 2010

Oracle's Software Configuration Manager version 10.1.2.5 with forms version 10.1.2.3.0:

Is this what everybody is using to manage their forms development? If not, what are developers using for Forms 10g version control? I've installed this software. I'm using the Oracle XE database for this repository. At least for running through the tutorial to figure out how this is to work.

I have to say that I am frustrated that I cannot compare one version of a form to another version of the same fmb. I get a java null pointer exception. I have uninstalled the repository using RAU, then recreated it using the RAU. I'm using version control and defining a "large" repository type for more than 10 developers.

View 6 Replies View Related

RAC & Failsafe :: Software Version In RAC

Jul 14, 2013

I heard, in RAC environment both clusterware software and oracle software should have similar version.how to find the version of both softwares ?

View 2 Replies View Related

SQL & PL/SQL :: How Many Column Can Be In Table (9i Version)

Apr 8, 2011

How many column can be in a table (9i Version)?

View 1 Replies View Related

Forms :: 9i Not Running At IE 8 Or Later Version?

Jan 9, 2013

I have developed my PAYROLL application in forms 9i, which is successfully runnig at internet explorer version 6 but it is not running at internet explorer version 8 or later.

View 1 Replies View Related

Database Refresh In Different Version?

Aug 24, 2012

Oracle 11.2.0.1 and 11.2.0.3.

Can rman refresh database from 11.2.0.1 to 11.2.0.3?

In another words, my source database is 11.2.0.1, my target database is 11.2.0.3

I want to refresh target database from source database. Is it ok since version is different?

View 6 Replies View Related

Oracle 9 Is Incompatible With Version Or Windows

Nov 9, 2010

I am trying to install Oracle 9i 32bit client on a windows 2008 server 64 bit OS. In the installation once I select the Oracle home directory and click on Next the whole pc just hangs. Nothing happens. When I checked the Application log I see an error with the following information.

the application (Oracle 9, from vendor Oracle) has the following problem. Oracle 9 is incompatible with this version or windows. For more information, contact Oracle.

View 13 Replies View Related

Upgrade RAC From Base Version To Patchset 3

Oct 4, 2010

I have one query regarding ORACLE 10g RAC.

I have installed 10gRAC [10.2.0.1] on VMware.

now I have requirement to upgarde it this existing RAC setup to 10.2.0.4.

options for me the steps or sequence I need to follow in upgrade path? like first needs to upgarde crs,then fro ASM and lastly for DB something like this.

View 5 Replies View Related

Exadata :: Tell Version Of Machine Connected To?

Mar 8, 2013

How can I tell version of exadata machine I'm connected to? Mean whether X2, X3-2. X3-8 ....

example: machinemodel=X2-2 Full rack A file named config.dat is mentioned in this doc [URL]

but I could not find that file on server I'm connected to (DB Host)

Any command, file I could use to get machinemodel?

View 9 Replies View Related

Forms :: After Deploying New 11g Fmx / Old Version Is Still Running

Apr 12, 2011

We are running forms 11g ( 11.1.1.3) in our production environment and we are having strange issue when we are deploying the new version of fmx on fusion middleware server ( Windows 2008). After copying/replacing the new fmx we are still running the OLDER version of form. It's happening randomly on different servers.

View 3 Replies View Related

Forms :: Supported IE Browser Version For 10g

Oct 9, 2013

Currently i am using IE 6 for running my forms 10g, I like to know upto which IE Versions i can update so it must not affect my Oracle forms 10g running.

i like to update to IE 8, but it must not affect my forms runtime functionality!

View 3 Replies View Related

SQL & PL/SQL :: Version Wise Objects Information?

Dec 11, 2012

Is there any way to capture the version wise objects (Packages) information from the oracle data base.

Ex : I have package P1 which was created on 01-NOV-2012 with version 1 . After 10 days same package has been updated version 2 with some enhancements.Like that the package will be updated according to the latest requirement.

Now I need to capture the total audit trail history of the package with version wise specific changes and when changes has been occurred hoe can I achieve this?

View 2 Replies View Related

Server Administration :: Oracle Version?

Mar 21, 2011

In my test server ..When i'm going to check the oralce verion .which version this one ? im not seeing anything from oracle EE or standard edition & personal edition ...

SQL> select BANNER from v$version;
BANNER
----------------------------------------------------------------
Oracle Database 10g Release 10.2.0.4.0 - 64bit Production
PL/SQL Release 10.2.0.4.0 - Production
CORE 10.2.0.4.0 Production
TNS for Linux: Version 10.2.0.4.0 - Production
NLSRTL Version 10.2.0.4.0 - Production

View 2 Replies View Related

PL/SQL :: Oracle Version Is 10g - Bulk Update?

Apr 18, 2013

My oracle version is 10g.I want to update a table which has 2 million rows and 20 columns. I want to update 3 columns in my table based on a query output.

Say:-
select decode(col1,'a',col2,col3) up_col1, decode(col5,'Y',20,30)* col6 up_col2, col7 up_col3 from base_tab a, update_tab b where a.key = b.key

I tried the simple update SQL, it hangs and never comeback even after 2 hrs.So I resort to PLSQL to complete my job using bulk collect with limits. Now I am stumbled upon with the Bulk update step.I referred to the BULK Update example given in [URL]...

I gone by 9i approach, I got invalid rowid error. Since the example doesn't uses a join.

I am little bit worried to go by 10g approach given in the example. I have to fetch entire row from my update table. My update table has 5 varchar(1000) fields. Anyway I am not going to affect them in my update. Whether it will occupy memory and again leads to hanging of my procedure.

View 2 Replies View Related

Application Express :: Get Version Currently In PROD From CVS

Jul 4, 2012

We use Apex 4.0.1 and (to simplify) say we have 2 environments: DEV and PROD (both with same workspace ID.)Application 10 is in production, and currently being modified in DEV as part of an improvement project.However a bug is found in PROD and needs to be fixed as soon as possible. The steps we take are:

- Get the version currently in PROD from CVS
- Import it under a different application ID in the DEV environment, say application 11.
- Fix the bug

Now the problem starts. We always deploy whole applications to other environments (rather than individual components) and we want to keep the same application ID when we deploy this fix to PROD. But we only have the run-time environment in PROD, so it is not possible to override the application ID during deployment. So what we do is:

- Export DEV application 10 (the one being modified)
- Export DEV application 11 (the one with the bug fix)
- Import DEV application 11 over application 10
- Export DEV application 10 (the one with the bug fix)
- Import DEV applicaton 10 back (the one being modified)
- Deploy DEV application 10 to PROD (the one with the bug fix)

Is there a way to improve this (other than manually modifying the application ID in the export file)?

Another problem we have is that, once application 10 is imported into application 11, all the internal IDs change (hence the title of this post. :) ) This makes comparing versions in CVS a nightmare. Any way to prevent it? The only way seems to be import the application from PROD into the same application number in DEV, but this has an impact in the development process as no new development can be done until the bug is fixed.

View 7 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved