What am I doing wrong. Please Help
An unhandled exception of type ‘Oracle.DataAccess.Client.OracleException’ occurred in oracle.dataaccess.dll Additional information: System error. Imports System.Data Imports Oracle.DataAccess.Client Public Class Form1 Inherits System.Windows.Forms.Form Dim objConnection As OracleConnection = New _ OracleConnection(“User Id=system;Password=dax856;Data Source=DMS”) Dim objDataAdapter As New OracleDataAdapter Dim objDataSet As DataSet = New DataSet Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles [...]

Answer Question   |  March 10, 2009  1:45 PM
Oracle 9i, Oracle Data Access, Oracle Database, Oracle error messages

OracleClient
I am new to VB.Net, I am using VB.Net 2003 and Oracle 10g Express. In coding I enter Imports System.Data.OracleClient The system did not support. Why??

Answer Question   |  March 5, 2009  8:14 PM
Oracle 10g, Oracle 10g Express, Oracle error messages, OracleClient, VB.NET, VB.NET 2003

PL/SQL error
Hi Experts, I am getting the follwoing error ORA-08102: index key not found, obj# 141051, file 28, block 15245 (2) I tried rebuild on that specific obj id still error persist wat are the possible causes and how to overcome please guide me

Answer Question   |  February 9, 2009  8:32 AM
ORA-08102, Oracle development, Oracle error messages, PL/SQL, PL/SQL error messages

ORA-03113: end-of-file on communication channel
I am running a database health report which consists of many SQLs against the data dictionary. Every SQL returns fine except one querying for chained/ migrated rows which takes a little more time, and I get the following: ERROR at line 1: ORA-03113: end-of-file on communication channel I am running this script as part of [...]

Answer Question   |  February 10, 2009  3:54 PM
ORA-03113, Oracle error messages, Oracle SQL, SQL, SQLPlus

PL/SQL Insert
Hi Experts, I am trying to do 2 INSERT stms on 2 tables consecutively n same transaction and my first insert is successful while doing the insert on second table which is completely carry same set of attibutes and values of 1st table + 1 additional static value attribute,it gives ORA :01400 error for primary [...]

Answer Question   |  January 20, 2009  11:00 AM
INSERT statement, ORA-01400, Oracle development, Oracle error messages, PL/SQL, PL/SQL procedure

I am getting ORA-01422: Exact fetch returns more than requested number of rows
Hi experts, I am getting this error when I run my test case for my PL/SQL procedure, which has select and insert statements only. Not clear where I would have went wrong, Please guide me where should I check exactly. Its popping up with this error message which i caught in a exception piece after [...]

Answer Question   |  April 19, 2013  10:56 AM
INSERT statement, ORA-01422, Oracle development, Oracle error messages, PL/SQL error messages, SELECT statement

PLS-00103: Encountered the symbol “E_PROD_REQ_ID_NOT_FOUND” when expecting one of the following:
how can i resolve that error? when i compile the store proc….it compiled without any errors….but in a package its throwing error

Answer Question   |  December 13, 2008  8:50 PM
Oracle error messages, PLS-00103, Stored Procedures

Oracle9i Release 1.0.2.2.2a Application Server Install – Enterprise Edition
I am installing the Forms and Reports Server component only first. But it hangs when it get to 100% and it is saying “Installing Oracle9i Application Server 1.0.2.2.2a” It hangs after prompting a blank command line and it seems it is trying to run something. Here is the last line on the installActions.log Calling action [...]

Answer Question   |  December 9, 2008  4:33 AM
Oracle 9i error messages, Oracle 9i installation, Oracle Developer Suite, Oracle error messages, Oracle Forms, Oracle installation, Oracle Reports, Oracle Reports 9i

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

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

ORA-27101: Shared memory realm does not exist
ora-27101:shared memory realm does not exist

Answer Question   |  November 19, 2008  9:17 AM
ORA-27101, Oracle error messages, Shared memory realm does not exist

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

rep-002
I am getting error “rep-002:Unable to retrieve a string from the report builder message file ” while opening a existing report in Reports 9i…How to solve this?

Answer Question   |  November 4, 2008  1:18 PM
Oracle 9i, Oracle error messages, Oracle Reports, Oracle Reports 9i, REP-002

ORA-00600
What is the solution to this ORA-00600:internal error code, arguements: [kksfbc_reparse_infinite_loop],[],[],[],[],[],[],[]

Answer Question   |  November 3, 2008  3:01 PM
EXP dump files, ORA-00600, Oracle error messages, Oracle import/export

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

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

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

NUMBER IN A LIST
I am trying to do an update statement with a where clause that has a number table column in a string list. The string when displayed is ####, ####, ####; with no quote marks. This is in a when-button-pressed trigger in a form. It appears to work when the list only has 1 number in [...]

Answer Question   |  October 15, 2008  2:31 PM
ORA-01722, Oracle error messages

Oracle initialization error while running Java files
I am facing no issues while compiling the java file. However while running the same, I am facing the following error. java.sql.SQLException: ORA-01033: ORACLE initialization or shutdown in progress. Any pointers for the same?

Answer Question   |  October 13, 2008  7:13 AM
Java, java.sql.SQLException, ORA-01033, Oracle error messages