在存儲過程中想傳入一個二進制數組,保存到Oracle中的blob字段中

程序出現下面錯誤:

ORA-01460: 未實現或無理的轉換請求

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Data.OracleClient.OracleException: ORA-01460: 未實現或無理的轉換請求

Source Error:

Line 108:? ? ? ? ? ? ? ? ? ? ? ? oraParm = null;

Line 109:

Line 110:? ? ? ? ? ? ? ? ? ? ? ? oraCmd.ExecuteNonQuery();

Line 111:

Line 112:? ? ? ? ? ? ? ? ? ? ? ? oraCmd = null;

Source File: c:\inetpub\wwwroot\forum\components\binaryobject.cs? ? Line: 110

Stack Trace:

[OracleException: ORA-01460: 未實現或無理的轉換請求

]

System.Data.OracleClient.OracleConnection.CheckError(OciHandle errorHandle, Int32 rc)

System.Data.OracleClient.OracleCommand.Execute(OciHandle statementHandle, CommandBehavior behavior, Boolean isReader, Boolean needRowid, OciHandle& rowidDescriptor, ArrayList& refCursorParameterOrdinals)

System.Data.OracleClient.OracleCommand.Execute(OciHandle statementHandle, CommandBehavior behavior, Boolean needRowid, OciHandle& rowidDescriptor)

System.Data.OracleClient.OracleCommand.ExecuteNonQueryInternal(Boolean needRowid, OciHandle& rowidDescriptor)

System.Data.OracleClient.OracleCommand.ExecuteNonQuery()

Forum.BinaryObject.UploadFile(Int32 intFileLength) in c:\inetpub\wwwroot\forum\components\binaryobject.cs:110

Forum.BinaryObjectAdd.UploadFill() in c:\inetpub\wwwroot\forum\binaryobjectadd.aspx.cs:80

Forum.BinaryObjectAdd.cmdBinaryAdd_Click(Object sender, ImageClickEventArgs e) in c:\inetpub\wwwroot\forum\binaryobjectadd.aspx.cs:57

System.Web.UI.WebControls.ImageButton.OnClick(ImageClickEventArgs e)

System.Web.UI.WebControls.ImageButton.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument)

System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument)

System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData)

System.Web.UI.Page.ProcessRequestMain()

--------------------------------------------------------------------------------

Version Information: Microsoft .NET Framework Version:1.1.4322.573; ASP.NET Version:1.1.4322.573

我的存儲過程是這樣寫的,請大俠們指點一下

PROCEDURE UP_BINARYOBJECTADD(OBJECTID NUMBER,OBJECTTYPE VARCHAR2,OBJECTVALUE LONG RAW,OBJECTLENGTH NUMBER)

IS

B_OBJECTVALUE BLOB;

BEGIN

INSERT INTO TBLBINARYOBJECT(OBJECTID,OBJECTTYPE,OBJECTVALUE)

VALUES(OBJECTID,OBJECTTYPE,EMPTY_BLOB())

RETURNING OBJECTVALUE INTO B_OBJECTVALUE;

DBMS_LOB.WRITE(B_OBJECTVALUE,OBJECTLENGTH,0,OBJECTVALUE);

END UP_BINARYOBJECTADD;

總結

以上是生活随笔為你收集整理的c oracle long raw,初次用Oracle,不会用Long Raw类型,请大家帮忙看看的全部內容，希望文章能夠幫你解決所遇到的問題。

如果覺得生活随笔網站內容還不錯，歡迎將生活随笔推薦給好友。