Oracle 10g Questions


oraoledb non working WHERE clause character comparison
Are there WHERE clause character comparisons that do not work when using oraoledb? I have a SQL query that is well formed and works with both Oracle 9 and Oracle 10g client, but will not execute when parsed via oraoledb.

Answer Question   |  December 11, 2008  1:47 PM
Oracle 10g, Oracle 9i, OraOLEDB, OraOLEDB.Oracle, SUBSTR, WHERE statement
asked by:
5 pts.

VB6 Oracle 10 Stored procedures with parameters
I have a vb6 – RDO code that works ok with Oracle8, recently there was an upgrade to Oracle 10g enterprise. Now I get the error 40041 -> Object Collection: Couldn’t find item indicated by text. 1110 lstrSQL = "{call Pyramid.Load_Tables(?, ?, 0)}" 1120 Set lrdoQ = vConexionDatos.MiDataBase.CreateQuery("ProcessTables", lstrSQL) 1130 lrdoQ.rdoParameters(0).Direction = rdParamInput 1140 lrdoQ.rdoParameters(0).Type [...]

Answer Question   |  December 11, 2008  8:20 PM
Oracle 10g, Oracle error messages, Oracle stored procedures, Oracle upgrades, VB 6, Visual Basic
asked by:
35 pts.

menu access when running forms 10gr1
when running froms I can’t get the menu bar to dropdown. the menu option is highlighted but it does not dropdown to reveal options. this only happens on my machine as when I logon to other peoples machines it seems to work fine. I’m using the same config files as the others. please help.

Answer Question   |  March 14, 2009  3:06 PM
Oracle 10g, Oracle Forms, Oracle Forms 10g
asked by:
Ma1
10 pts.

Oracle 10g Instance not starting Up
Oracle 10g startup command from SQL Plus gives the following error: ORA-01034 : ORacle not available ORA-27101: shared memory realm does not exist

Answer Question   |  December 1, 2008  2:03 AM
ORA-01034, ORA-27101, Oracle 10g, Oracle 10g error messages, Oracle error messages, Oracle not available, Shared memory realm does not exist, SQLPlus
asked by:
15 pts.

can we install oracle10g client version and oracle 10g server on the same machine? will it work fine?
can we install oracle10g client version and oracle 10g server on the same machine? will it work fine? If there will any problem so what will the problem? Please any one explain me. Thanks in advance. It’s urgent please

Answer Question   |  December 1, 2008  7:02 AM
Oracle 10g, Oracle 10g Client Version, Oracle 10g Server
asked by:
5 pts.

use 32gb ram with oracle 10g and windows 32bits
how can i use 32GB ram with windows 32bits and oracle 10g?

Answer Question   |  December 1, 2008  7:49 PM
Oracle 10g, Win32
asked by:
5 pts.

OS/400 V5R3MO to Oracle 10g
I like to migrate a database which is in IBM OS/400 V5R3MO (Source)using iseries navigator to Oracle 10g.In the source database there are few stored procedures which I like to migrate from source to oracle too. As I know Oracle migration workbench works on V4R5 0R V4R3 but not on V5R3MO .So there any other [...]

Answer Question   |  June 9, 2010  2:44 PM
iSeries, Migration from OS/400 to Oracle 10g, Oracle 10g, Oracle Migration Workbench, OS/400, OS/400 and iSeries, V5R3MO
asked by:
55 pts.

Migration
I like to migrate a database which is in IBM OS/400 V5R3MO (Source)using iseries navigator to Oracle 10g.In the source database there are few stored procedures and few triggers which I like to migrate from source to oracle too. So I like to know is Oracle migration workbench will able to do so or is [...]

Answer Question   |  November 26, 2008  10:58 PM
iSeries, Migration from OS/400 to Oracle 10g, Oracle 10g, Oracle Migration Workbench, OS/400, OS/400 and iSeries, V5R3, V5R3MO
asked by:
55 pts.

DB2/400 to Oracle 10g
I like to migrate a database which is in IBM DB2 /400 V5R3MO supported by windows platform (Source)using iseries navigator to Oracle 10g.In the source database there are few stored procedures and few triggers which I like to migrate from source to oracle too. So I like to know is Oracle migration workbench will able [...]

Answer Question   |  November 21, 2008  8:03 PM
AS/400 migration, DB2/400, iSeries Navigator, Migration from DB2/400 to Oracle 10g, Oracle 10g, Oracle migration, Oracle Migration Workbench, V5R3
asked by:
55 pts.

How to run Oracle 10g forms on browser
Hello everyone, When I run form browser, it shows only Oracle forms. Please help me solve my problem.

Answer Question   |  April 19, 2013  8:01 AM
Oracle 10g, Oracle Forms, Oracle Forms 10g
asked by:
5 pts.

migration How to migrate from oracle 10g to Hp unix?
How to migrate from oracle 10g to Hp unix?

Answer Question   |  September 27, 2011  1:12 PM
HP Unix, Oracle 10g, Oracle migration, Unix, Unix migration
asked by:
10 pts.

ODBC connectivity to Oracle 10g database from an Oracle 6i client
Talking through VB Code from a Oracle 6i Client to a 10G database using ODBC.

Answer Question   |  November 14, 2008  11:34 AM
Database connectivity, ODBC, Open Database Connectivity, Oracle 10g, Oracle 6i, VB, Visual Basic
5 pts.

Oracle Replication
how to configure basic replication in oracle 10g express

Answer Question   |  September 7, 2010  11:55 AM
Oracle, Oracle 10g, Oracle 10g basic replication, Oracle 10g Express, Oracle 10g replication, Oracle basic replication, Oracle replication
asked by:
15 pts.

Forms not connecting to upgraded Oracle 8.1.7 database to Oracle 10g R1
i have upgraded my oraCLE 8i database to 10R1 and am trying to connect my oracle 6i froms to it. After doing the connection when i try to log into the application it tells me that the password and the user name is incorrect. i have tried with a different user details but its not [...]

Answer Question   |  November 5, 2008  9:44 AM
Oracle 10g, Oracle 10g R1, Oracle 8.1.7, Oracle 8i, Oracle error messages, Oracle Forms, Oracle Forms 6i, Oracle interoperability
asked by:
5 pts.

rep-51002
hello i have problem when i need to run the report 10g via form builder 10g by using web.show_document ,the error rep-51002 appear how can i solve that please where i am using oracle database 10g and oracle developer suite 10g on the same pc under windows .. thanks

Answer Question   |  October 28, 2008  3:55 PM
Oracle 10g, Oracle error messages, Oracle Form Builder, Oracle Forms, Oracle Reports, Rep-51002
asked by:
5 pts.

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
asked by:
Rat
15 pts.

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
5 pts.

Migrating from Sybase to Oracle 10g
I know the a little more than the basics of DBing but not as much as an OCA or OCP. I need to know how to migrate data over from Sybase to Oracle 10g on a very large scale! Please help! I do not want to use a conversion software because there are many updates [...]

Answer Question   |  October 16, 2008  12:41 PM
Oracle 10g, Oracle migration, Sybase
asked by:
5 pts.

Monitoring Object changes in Oracle
I have to find out who modified objects in dba_objects each week for those changed during that week for SOX perspective. Right now i check with deveplopers for each one, which they don’t like. I question is how to find out who modified an object in 9i or 10g (and 11i)?

Answer Question   |  April 7, 2010  6:17 PM
dba_objects, Oracle 10g, Oracle 11i, Oracle 9i, Oracle administration, Sarbanes-Oxley Act, SOX
asked by:
65 pts.

Integration of Oracle Reports with Oracle Forms
how to integrate oracle reports in developer suite 10g with oracle form

Answer Question   |  February 14, 2011  3:17 AM
Developer Suite 10g, Oracle 10g, Oracle Forms, Oracle Reports
asked by:
5 pts.