Oledb Oracle Stored Procedure Unspecified Error
Contents |
CommunityOracle User Group CommunityTopliners CommunityOTN Speaker BureauJava CommunityError: You don't have JavaScript enabled. This tool uses JavaScript and much of it will not work correctly without it enabled. Please turn JavaScript back on and reload execute sql server stored procedure from oracle this page. Please enter a title. You can not post a
Call Oracle Stored Procedure From Sql Server Linked Server
blank message. Please type your message and try again. More discussions in Oracle Provider for OLE DB All server is not configured for rpc PlacesDatabaseDatabase Application DevelopmentWindows and .NETOracle Provider for OLE DB This discussion is archived 1 Reply Latest reply on Aug 3, 2005 4:53 PM by 238679 OraOLEDB error '80004005' (more) 238679 Aug 2, 2005 5:10 PM Immersed in an SQL-Server to Oracle conversion project with many SQL-Server stored procedures that return record sets. I am attempting to establish the proper method of returning record sets to the .ASP code so as to minimize the changes required to that code. Conversion of SQL-Server stored procedures to Oracle PL/SQL is progressing smootly. PROBLEM: OraOLEDB error '80004005' when calling Oracle stored procedures that return result sets from .ASP Anyone have any ideas what I can do to fix this? TRIED: 1) Granting Read/Write/Execute on Oracle Home directory on Web Server 2) Modifying Windows Registry to point to proper Oracle Home .dll's for latest 10g Client 3) Moving the REF CURSOR parameter in the stored procedure to the end of the parameter list ENVIROMENT: Oracle 10.1.0.2 Server Oracle Provider for OLE DB release 10.1 Microsoft IIS Server 5.0 (Win 2000) CODE: <%@LANGUAGE="VBSCRIPT"%> <% SysCatConnString = "Provider=OraOLEDB.Oracle;" & _ "Data Source=BPDB;" & _ "User ID=utst;" & _ "Password=cat;" & _ "PLSQLRSet=1;" Set objConnection = Server.CreateObject("ADODB.Connection") objConnection.Open SysCatConnString If objConnection.Errors.Count = 0 Then Response.Write "
NO connection errors" End If connState = objConnection.State Response.Write "
connState = " & connState set cmd = Server.CreateObject("ADODB.Command") cmd.ActiveConnection = objConnection cmd.Parameters.Append cmd.CreateParameter("p_Application_ID", adSmallInt, adParamInput, , 2) cmd.Parameters.Append cmd.CreateParameter("p02_Userid", adBSTR, adParamInput, 4, "test") cmd.Parameters.Append cmd.CreateParameter("p03_Password", adBSTR, adParamInput, 4, "test") cmd.Parameters.Append cmd.CreateParameter("spRetVal", adSmallInt, adParamOutput) cmd.CommandText = "{ CALL dbo.up_sc888Us
runtime error while trying to call PL/SQL ref cursor from VB using ADO rated by 0 users This post has 6 Replies | 1 Follower mmk1212 Since 3/20/2006 Posts 3 Reputation 75 Reply M K (mmk1212) Posted: 3/20/2006 7:27 AM rated by 0 users have a form in MS Access/vb and I am trying to connect to Oracle Database and call a ref cursor in Oracle PL/SQL https://community.oracle.com/thread/319765 procedure using ADO.I am able to connect successfully, but when I execute the command (when I call the ref cursor) I get a RUNTIME UNSPECIFIED ERROR.In my procedure p_user_id is an input numeric variable and then there is a ref cursor. Following is my code (please help me determine what am I missing):Option ExplicitPublic http://vbcity.com/forums/t/120002.aspx m_adoCnn As New ADODB.ConnectionPublic m_adoRst As New ADODB.RecordsetPrivate Sub Command0_Click()Dim Cn As ADODB.ConnectionDim CP As ADODB.CommandDim Rs As ADODB.RecordsetDim Conn As StringDim SSQL As StringDim Pr As New ADODB.ParameterSet CP = New ADODB.CommandSet Cn = New ADODB.Connection'Connect to Oracele server beginConn = "Provider=OraOLEDB.Oracle;Data Source=x;UserID=y; Password=z;PLSQLRset=1;"With Cn.ConnectionString = Conn.CursorLocation = adUseClient.OpenEnd WithIf Cn.State = adStateOpen ThenMsgBox "Connection successful."End IfSSQL = "{call test_pkg.test_PROC(?)}"With CP.ActiveConnection = Cn.CommandType = adCmdStoredProc.CommandText = SSQL.Parameters.Append .CreateParameter("p_user_id", adNumeric, adParamInput, , 5)Set Rs = .Execute()End With'Connect to Oracle server end'close connection beginCn.CloseSet Cn = NothingSet CP = Nothing'close connection endEnd SubPrivate Sub Form_Unload(Cancel As Integer)m_adoCnn.CloseEnd Sub | Post Points: 65 Pyash NY Since 4/2/2003 Posts 4,298 Reputation 29,110 Reply Gilles Joseph (Pyash) replied on 3/20/2006 5:43 PM rated by 0 users I used to have some sample code some where, but couldn't locate it. Anywaycheck this post and see that helps.regards,Pysah | Post Points: 5 mmk1212 Since 3/20/2006 Posts 3 Reputation 75 Reply M K (mmk
Unanswered Topics Wrox Programmer Forums > .NET > Other .NET > General .NET 'Unspecified error' on ExecuteNonQuery function in ORACLE User Name http://p2p.wrox.com/general-net/75240-unspecified-error-executenonquery-function-oracle.html Remember Me? Password Reminder Password Register Register | FAQ | Members List | Calendar | Today's Posts | Search General .NET For general discussion of MICROSOFT .NET topics http://www.dotnetheaven.com/article/oracle-stored-procedure-from-asp.net-in-vb.net that don't fall within any of the other .NET forum subcategories or .NET language forums. If your question is specific to a language (C# or Visual Basic) or type stored procedure of application (Windows Forms or ASP.Net) try an applicable forum category. ** PLEASE BE SPECIFIC WITH YOUR QUESTION ** When posting here, provide details regarding the Microsoft .NET language you are using and/or what type of application (Windows/Web Forms, etc) you are working in, if applicable to the question. This will help others answer the question without oracle stored procedure having to ask. Search Forums Show Threads Show Posts Advanced Search Find All Thanked Posts Go to Page... Welcome to the p2p.wrox.com Forums. You are currently viewing the General .NET section of the Wrox Programmer to Programmer discussions. This is a community of tens of thousands of software programmers and website developers including Wrox book authors and readers. As a guest, you can read any forum posting. By joining today you can post your own programming questions, respond to other developers’ questions, and eliminate the ads that are displayed to guests. Registration is fast, simple and absolutely free . Thread Tools Display Modes #1 (permalink) July 14th, 2009, 09:36 AM Dmitriy Friend of Wrox Join Date: Jul 2003 Location: , , . Posts: 121 Thanks: 1 Thanked 0 Times in 0 Posts 'Unspecified error' on ExecuteNonQuery function in ORACLE Hello, I am trying to execute the function in ORACLE database from my .NET code, but I am getting this 'Unspecified error' erro
how to call Oracle stored procedure from ASP.NET. 2342 I want to convert my app. from asp to asp.net. Having a lot of fun :-). The problem that I have now - I can't call Oracle stored proc. The asp code (works just perfect) is: Set objComm = Server.CreateObject("ADODB.Command") objComm.ActiveConnection = GetDBConnection() objComm.CommandText = "{ CALL praxis_search_pkg.bpmbhg_ref_cursors(?, ?, ?, ?) }" objComm.CommandType = adCmdText Set param1 = objComm.CreateParameter("pi_table", adVarChar, adParamInput, 100, pi_table) objComm.Parameters.Append param1 Set param2 = objComm.CreateParameter("pi_string", adVarChar,adParamInput,500, querystr) objComm.Parameters.Append param2 Set param3 = objComm.CreateParameter("pi_max",adNumeric, adParamInput, 100, 6) objComm.Parameters.Append param3 Set param4 = objComm.CreateParameter("po_status_code", adInteger,adParamOutput) objComm.Parameters.Append param4 objComm.Properties("PLSQLRSet") = true Const cConnection = "Provider=OraOLEDB.Oracle; Data Source=[database]; User ID=[username]; Password=password]; DistribTX=0; ChunkSize=65000; cachetype=file;" Private Function GetDBConnection() Set objConnection = Server.CreateObject("ADODB.Connection") objConnection.ConnectionString = cConnection objConnection.CursorLocation = adUseClient objConnection.Open Set GetDBConnection = objConnection End Function TheVB.NET code that I wrote is: Private strProcName As String = "{ CALL praxis_search.bpmbhg_ref_cursors(?, ?, ?, ?) }" Private objConnect = New OleDbConnection("Provider=OraOLEDB.Oracle;Data Source=praxislinux;User ID=praxisuser;Password=oracle;DistribTX=0;") Private sqlCommand As OleDbDataAdapter = New OleDbDataAdapter(strProcName, objConnect) Private sqlCommand.SelectCommand.CommandType = CommandType.Text Private param1 As OleDbParameter = New OleDbParameter("pi_table", OleDbType.VarChar, 100, "prx_bpm_index") Private param1.Direction = ParameterDirection.Inpu