Oracle Developer 10g Express Edition and Oracle Database 10g
can we use same edition at same time? like we are use express edtion of oracle databse 10g and also use oracle developer 10g express edition at same time?

Answer Question   |  October 27, 2008  5:26 PM
Oracle 10g, Oracle Database 10g, Oracle Developer 10g, Oracle Developer 10g Express Edition

ORA-00257
What’s the quickest way to resolve an ORA-00257 error? What are some ways to prevent this from happening?

Answer Question   |  February 2, 2010  12:43 PM
ORA-00257, Oracle error messages, Redo logs

Oracle, MySQL connectivity by HSODBC
Hello, We have tried to connect with MySQL from Oracle 10g Rel.2 through HSODBC and getting the following error: ERROR at line 1: ORA-28545: error diagnosed by Net8 when connecting to an agent Unable to retrieve text of NETWORK/NCR message 65535 ORA-02063: preceding 2 lines from MYSQLDB Both MySQL and Oracle are running on windows [...]

Answer Question   |  October 27, 2008  6:04 AM
Database connectivity, HSODBC, MySQL, ORA-02063, ORA-28545, Oracle, Oracle 10g, Oracle error messages, Solaris

Run scheduled job on SQL Server
we do integrate SQL SERVER woth Oracle database, and its usually work withour problems. the last two days the intgration is not working and the following error displayed in the job history. Cannot create COM Server to load and execute DTS Package. Error -2147221008 (800401F0): CoInitialize has not been called. Process Exit Code -2147221008. The [...]

Answer Question   |  October 27, 2008  6:20 AM
COM server, Database interoperability, DTS packages, Error 2147221008, Oracle interoperability, Runtime Errors, SQL Server 2000, SQL Server errors, SQL Server interoperability

Linked Server Query Returns Incomplete Results
I have set up a linked server using Microsoft OLE DB Provider for ODBC Driver to an Oracle DB ODBC DSN. The Oracle table I’m querying has 865 rows but when I try to fetch all the rows I only get back 766 rows. Why am I not getting the complete results? Here is the [...]

Answer Question   |  January 6, 2011  12:42 PM
Linked servers, ODBC, OLE DB, Oracle Database

Oracle E-Business Suite R12
Can Oracle E-business Suite R12 run on-line real time like SAP?

Answer Question   |  October 24, 2008  8:31 AM
Oracle E-Business Suite, Oracle E-Business Suite R12, Real time

Page Down/Page Up Lockup in P9612 (Function Keys Security)
Hi there, can anyone pls enlighten me on whether it is possible to “lock” the scroll up/scroll down function keys on a certain program screen in JDE World version (A7.33). For example, I don’t want users to be able to display the next records in P4310 screen when they pressed the page/down or page up [...]

Answer Question   |  October 24, 2008  8:19 AM
JD EDWARDS, JDE, JDE World

Replace a variable part of a string in a varchar2 field
I have a vendor Oracle table containing data as follows column name: PVC_Value value = TRKCASETRK;6,0,0,0,0,0,0;;20801911;32004910;43175007;2,2;0;59647;1,30;0;0;3002 As you can see this field contains data delimited by semi-colons (for 13 elements) I need to relace the 7th and 10th elements in this string, so in the case above I need to replace the substring 2,2 with [...]

Answer Question   |  October 24, 2008  9:06 PM
Oracle PL/SQL, Oracle Table, VARCHAR

Oracle Reports duplicate labels
Using the oracle reports mailing label style, i would like to print an entire sheet of labels using the SAME record. each record prints an entire page of duplicate labels. best way to do it?

Answer Question   |  October 24, 2008  8:36 PM
Oracle printing, Oracle Reports

Updating Microsoft SQL Server tables from Oracle generates error
i am not able to update table in ms sql2000 from oracle . can u sugegstyour views on this . the error i got is ORA-00904: “NAME”: invalid identifier.

Answer Question   |  October 22, 2008  8:58 AM
Microsoft SQL Server 2000, ORA-00904, Oracle error messages, Oracle import/export, SQL Server 2000, SQL Server import/export

Oracle Forms
How to find out what my Oracle Forms version on my desktop?

Answer Question   |  October 21, 2008  7:14 PM
Oracle Forms, Oracle Forms 6i

relationship between two or more forms in DS10g
i want to create relationship between two or more forms in DS10g for example i want acces one field like Emp_ID on other form how can i do?

Answer Question   |  October 21, 2008  12:25 PM
DS10g, DS10g Forms

Turn JDE skill into Oracle E-business Suite skill
I know JDE. I want to learn oracle e-business suite. What must I do?

Answer Question   |  September 30, 2010  9:10 PM
Career development, E-Business Suite, JD EDWARDS, JDE, Oracle certifications, Oracle E-Business Suite

Want to know about Oracle Reporting
Can anybody tell me sth about ORACLE report generation using Oracle 8i ?

Answer Question   |  October 21, 2008  11:27 AM
Oracle 8i, Oracle reporting, Oracle Reports

How to save the exported Excel files from Oracle Forms 6
Hi, I am using oracle forms 6.0. I generate multiple excel files from oracle forms and am using ole2 to export the data into excel. But i dont know how to save those files into the local machine. please someone help me. Thanks in advance

Answer Question   |  October 20, 2008  9:25 AM
Microsoft Excel, Object Linking and Embedding, OLE, Oracle Forms, Oracle import/export

install oracle 8i with ram more than 2G
I get error while i try to install oracle 8i like unable to calculate memory

Answer Question   |  October 20, 2008  8:04 AM
Oracle 8i, Oracle 8i Installation

Errors: Violation of UNIQUE KEY constraint ‘UN_FILENAME’. Cannot insert duplicate key in object
when i am migrating data from oracle9i to SQL2005 i am getting the error Errors: Violation of UNIQUE KEY constraint ‘UN_FILENAME’. Cannot insert duplicate key in object how should i solve the problem

Answer Question   |  October 20, 2008  10:41 AM
Oracle 9i, Oracle 9i to SQL Server 2005 Data Migration, SQL Server 2005

Moving from Unix to Windows
We are contemplating moving our databases from the Unix platform to a Windows platform. The Windows servers we are thinking of purchasing are Itanium. We have been told that we can just copy the datafiles from the Unix platform to the Windows platform and everything should work fine. I am not so sure and would [...]

Answer Question   |  November 9, 2008  3:32 PM
Itanium Servers, Oracle administration, Unix, unix to Windows Database Migration, Windows Server 2003

Spooling Oracle Output via SQL DTS
I am able to execute a stored procedure that resides in a database on an Oracle server via a DTS Package on a SQL Server. I would like to be able to spool the output to a .log file on a different server. Is this possible using DTS?

Answer Question   |  October 16, 2008  4:09 PM
DTS packages, Oracle, Oracle Output Via SQL, SQL Server, Stored Procedures

automate Oracle database backup on Windows 2000 server
Hello, I have to make a cold backup of our test database. The database is oracle 8.1.7 on a Windows 2000 server. I have made bat files to do this and have scheduled them in the Windows scheduled tasks application. This works fine. I check to see if my jobs have run successfully by looking [...]

Answer Question   |  October 17, 2008  1:43 PM
Backup, Database Backup, Oracle 8i, Oracle backup, Oracle database backup and recovery, Windows 2000 Server