Anyone have experience passing ~2MB sized data to an Oracle SP using
SQLEEXEC( ) or ADO? I need to pass entire files to an Oracle SP as an input
parameter of type BLOB or CLOB but cannot get it to work.
Thanks,
Bo Durban
** VFP Example:
nSQL = SQLSTRINGCONNECT( cOracleConnect )
cData = FILETOSTR("Document.pdf") && 2MB file
nResult = SQLEXEC(nSQL,"{call insert_file_blob(?cData)}") && C'005 error
cData = FILETOSTR("Document.pdf") && 2MB file
cData = STRCONV(cData, 13) && Convert to base64
nResult = SQLEXEC(nSQL,"{call insert_file_clob(?cData)}") && C'005 error
** ADO Example:
cData = FILETOSTR("Document.pdf") && 2MB file
cData = STRCONV(cData, 13) && Convert to base64
loConnection = CREATEOBJECT( "ADODB.Connection" )
loConnection.CursorLocation = 2 && server-side cursor
loConnection.Open( cOracleConnect )
loCommand = CREATEOBJECT( "ADODB.Command" )
loCommand.CommandType = 4 && by SP name
loCommand.CommandText = "insert_file_clob"
loCommand.ActiveConnection = loConnection
loParameter = loCommand.CreateParameter()
loParameter.Name = "p_lob" && name we assign
loParameter.Type = 201 && long varchar string type
loParameter.Direction = 1 && input parameter
loParameter.Size = LEN(cData) && maximum length
loParameter.Value = cData && initialize the parameter
loCommand.Parameters.Append( loParameter )
loCommand.Execute() && Error:
&& OLE IDispatch exception code 0 from Microsoft OLE DB Provider
&& for ODBC Drivers: [Oracle][ODBC][Ora]ORA-01460: unimplemented
&& or unreasonable conversion requested
RELEASE loCommand
loConnection.Close
RELEASE loConnection
©2002 wdurban (AT) datascantech D.OT com |
