Execution of Oracle 11g wrapped procedure gives ora-00900 error
Hi, I have a procedure which I wrapped using the oracle 11g wrap utility. If I execute the wrapped procedure using JDBC I am getting an error of 0RA-00900 invalid SQL statement. The procedure is having basic SQL statements only. The same procedure if i wrap using Oracle 9i and execute using JDBC it works [...]

Answer Question   |  April 5, 2013  4:29 AM
Oracle 11g, Oracle 9i

How to sort a resultset from a ‘group by’ statement
I have written a query like this: select to_char(order_date,’mon-yyyy’) “months”, sum(nob) “number of bags” from p_in where order_date between ’1-apr-11 and ’31-mar-12′ group by to_char(order_date,’mon-yyyy’) The above query returns me a resultset which gives me number of bags sold in every month, but it does not sort the month in their chronological order.I want to [...]

Answer Question   |  March 11, 2013  4:20 AM
Oracle 11g, Oracle 11g Database, Oracle Query

Problem connecting D2K 6i with database Oracle 11g
Steps to connect D2K 6i, with oracle database 11g.

Answer Question   |  January 11, 2013  10:19 AM
D2K, Oracle 11g, Oracle 11g Database

Can anyone tell me what is the difference between oracle 10g and oracle 11g in way of comparison
Please, can anyone tell me what is the difference between Oracle 10g and Oracle 11g in way of comparison?

Answer Question   |  October 22, 2012  9:31 AM
Oracle 10g, Oracle 11g

oracle 11g oam console login on Win 2008
Has anyone been able to install OAM 11.1.1.5 on Win 2008 R2 and able to log in to the oamconsole?

Answer Question   |  August 27, 2012  8:59 PM
oanconsole, Oracle 11g, WIN 2008 R2

Query from Oracle forms to Excel sheet
I had a matrix report made in oracle reports builder 11g. This report was called from a button in my form. now, I want to open an excel file when that button is pressed and show the data exactly in the format as it was shown previously in the report which was made using report [...]

Answer Question   |  May 25, 2012  6:04 AM
Microsoft Excel, Oracle 11g

How to view Crystal Reports in Internet Explorer?
when i deploy my asp.net website on windows 7 with oracle 11g database in backend.I am using sap crystal report version 13.0.2000.0 It gives error as Unsupported Operation. A document processed by the JRC engine cannot be opened in the C++ stack.Description: An unhandled exception occurred during the execution of the current web request. Please [...]

Answer Question   |  May 24, 2012  6:01 AM
Crystal Reports, Oracle 11g

Materialized Views
I have a materialized view LOG on an Oracle 11 database and a materialized view on an Oracle 10 database. The LOG file does not recognize that the MV on Oracle 10 needs it for refreshing. The same setup on 10g to 10g works fine. Any ideas?

Answer Question   |  May 24, 2012  1:27 PM
Oracle 10g, Oracle 11g

ORA-03127: no new operations allowed until the active operation ends
Good Morning, Since oracle 10g and even after upgrading to oracle 11g , e keep getting an oracle error: ORA-03127: no new operations allowed until the active operation ends, in relation to a diferent db table, every time the error occurs. including db tables that have maintenunce every day. can anyone tell me why this error [...]

Answer Question   |  March 22, 2012  12:13 PM
ORA-03127, Oracle 11g, Oracle Reports 10g

oracle 11g – Linux – error – ORA-03114
Hi, i´m having a major instability problem with application servers, since the migration from oracle 10g windows db server to oracle 11g linux cluster. The oracle db sessions keep dying. which causes major instability to the application services , and to application users and i get tons of oracle errors: ORA-03114:  not connected to ORACLE help.thanks.

Answer Question   |  March 13, 2012  9:45 AM
Linux, Oracle 11g, Oracle 11g error messages

Oracle Multi-Master Replication
Hi.  I have set up Oracle Multi-Master Replication between two 11g’s, and it works OK. (Each database updating the other with the latest updates).  But I have not been able to get one database to automatically update the other when one has been taken off-line then reconnected after changes had been made to one of them.  Will you [...]

Answer Question   |  February 27, 2012  9:40 PM
Oracle 11g, Oracle replication, Windows XP Pro

oracle forms 11g – Calling .DLL files from forms
What is the best way to call a PRO C .dll file from forms 11g. (Would rather not have the files reside on the client)

Answer Question   |  October 12, 2011  2:10 PM
Oracle 11g, Oracle Forms, Oracle Forms 11g

Urgent converting Oracle forms & reports from 5i to 11g
how can i migrate oracle forms&reports 5i to 11g in 64 bit linux

Answer Question   |  March 31, 2012  8:34 AM
Linux servers, Oracle 11g, Oracle Forms, Oracle Reports

oracle explain plan from yesterday
Is it possible to see the explain plan used by Oracle for a select statement that was run yesterday?

Answer Question   |  March 31, 2012  6:08 AM
Oracle, Oracle 11g, Oracle administration, SELECT statement

Oracle report runtime request for usename and password
I’ve installed Oracle11g , my applications are still forms 6i, everything was perfect but when I try to run a report from my system, it ask for username and password connectivity, is there a missing configuration , Thank you for your wonderful help in advance

Answer Question   |  October 24, 2011  6:04 AM
Oracle 11g, Oracle Developer 6i, Windows Server 2008, Windows XP Pro

Oracle Enterprise Manager Console
Pls. can anyone help me with this error masage,whenever i try to start OracleDBConsole from the services. iam using oracle 11g database, windows 7 the error masage is “Oracle could not start OracleDBConsole on the local computer for more information review the Service Event Log. if this is a non-microsoft services, contact the service vendor, [...]

Answer Question   |  June 9, 2011  11:37 AM
Oracle 11g, Oracle 11g Database, Oracle Enterprise Edition, Oracle Enterprise Manager

sql statement…..
Can someone take a look at this code and please tell me what i am doing wrong? SQL> INSERT INTO “CDAAS”.”INFORMATION”   2  VALUES (‘MBedfo’,'Maurice’,'Bedford’,'Maurice Bedford’,”,”,’02/02/1990′,’1234′,”,”,”); VALUES (‘MBedfo’,'Maurice’,'Bedford’,'Maurice Bedford’,”,”,’02/02/1990′,’1234′,”,”,”)         * ERROR at line 2: ORA-01722: invalid number

Answer Question   |  May 3, 2011  4:27 PM
Oracle 11g, SQL Server, SQL statement

Oracle 11g error message
error message for oracle 11g- file not found- c:appdagdelproduct11.1.0db_2nlslbuilderlbuilder.dat

Answer Question   |  March 15, 2011  8:40 AM
Oracle 11g, Oracle 11g error messages, Oracle 11g installation, Oracle error messages

Need a plan for migrating from Oracle 10gR2 to Oracle 11g
Planning a migration from Oracle 10gR2 to Oracle 11g. Below are the specifications, what should I consider before starting a plan? Any experience in this – advice greatly appreciated. Conditions to meet during migration: 1) Currently Our Production Database 10gR2 is on Solaris server. (Server- N3000). 2) And now we are migrating to Oracle 11g [...]

Answer Question   |  June 8, 2010  3:31 PM
Oracle 10g R2, Oracle 11g, Oracle migration, Storage in 2010

Error – FRM-18103:
Hi, I have installed Oracle 11g Database and installed Oracle Developer suite 10g .. Error – FRM-18103:Failed to initialize the Development Environment I have installed Oracle 11g and Oracle Developer Suite 10g in separate oracle homes. When I try to open Oracle form builder I am receiving ‘FRM-18103:Failed to initialize the Development Environment’ error. Can [...]

Answer Question   |  July 1, 2010  10:29 AM
Forms 10g, Oracle 11g, Oracle 11g Database, Oracle Developer Suite, Oracle Forms Error Messages