Link to home
Start Free TrialLog in
Avatar of Collindsouza
CollindsouzaFlag for United Kingdom of Great Britain and Northern Ireland

asked on

ORA-00604: error occurred at recursive SQL level 1

Im developing a C# windows forms application  with an Oracle 9i database.

I get the following error when i try to connect to an oracle database from Visual Studio.NET.. However when i run the code from another PC it works fine... what could be the problem? Please Help!!!!

Event Type:      Warning
Event Source:      DocumentExtractionTool
Event Category:      None
Event ID:      0
Date:            04/03/2008
Time:            13:57:18
User:            N/A
Computer:      KEAUK08343
Description:
Application: DocumentExtractionTool (DocumentExtractionTool)  - Version: 1.0.0.0
Error Details as follows: ORA-00604: error occurred at recursive SQL level 1
ORA-06502: PL/SQL: numeric or value error: character string buffer too small
ORA-06512: at line 28


System.Data.OracleClient.OracleException: ORA-00604: error occurred at recursive SQL level 1
ORA-06502: PL/SQL: numeric or value error: character string buffer too small
ORA-06512: at line 28

   at System.Data.OracleClient.OracleException.Check(OciErrorHandle errorHandle, Int32 rc)
   at System.Data.OracleClient.OracleInternalConnection.OpenOnLocalTransaction(String userName, String password, String serverName, Boolean integratedSecurity, Boolean unicode, Boolean omitOracleConnectionName)
   at System.Data.OracleClient.OracleInternalConnection..ctor(OracleConnectionString connectionOptions)
   at System.Data.OracleClient.OracleConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningObject)
   at System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options)
   at System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject)
   at System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject)
   at System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject)
   at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection)
   at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)
   at System.Data.OracleClient.OracleConnection.Open()
   at DET.TestForm.button1_Click(Object sender, EventArgs e)

For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.


The code I usre to connect to the oracle database server is as follows
 
                connectionString = "Data Source=i021.World;Persist Security Info=True;User ID=Ops$Access;password=******;Unicode=True"
                OracleConnection conn = new OracleConnection(connectionString);
                OracleCommand cmd = new OracleCommand();
                cmd.Connection = conn;
                cmd.CommandText = "package.Get_StoredProc_DATA";
                cmd.CommandType = CommandType.StoredProcedure;
                cmd.Parameters.Add("p_Cur", OracleType.Cursor).Direction = System.Data.ParameterDirection.Output;
                conn.Open();

Open in new window

SOLUTION
Avatar of joebednarz
joebednarz
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Collindsouza

ASKER

actually the same error occurs when i simply use the conn.open() method without using the command object..

So I get the error even when using the following code

connectionString = "Data Source=i021.World;Persist Security Info=True;User ID=Ops$Access;password=******;Unicode=True"
OracleConnection conn = new OracleConnection(connectionString);
conn.Open();   <-------------- Error on this line.
ASKER CERTIFIED SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
no my password isnt 30 charecters long and i tried simplifying the connection string and it still gives me the same error.
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
i dont what it is... i think its more to do with Visual Studio behaving wierdly...

I created a new project and now i tried using the same connection parametes and it works fine... SO its not a Oracle thing... its just that visual studio access to db must be locked or corrupted somehow
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Thank you all for your reply..
i couldnt find the solution to this problem...

But i created another project and added the same code in it.. and it now works.. so there was soemthing wrong with that particular .NET IDE ...