急!!在线等待解决办法
CREATE OR REPLACE PROCEDURE WORKING.INSERT_SPOT_C_VOICE(p_id VARCHAR2,p_version VARCHAR2,p_voice OUT BLOB) IS
BEGIN
UPDATE C_VOICES
SET
SPOT_ID = p_id,
VERSION = p_version,
VOICE_DATA = EMPTY_BLOB()
WHERE
SPOT_ID = p_id
AND
VERSION = p_version
RETURNING
VOICE_DATA
INTO
p_voice;
END INSERT_SPOT_C_VOICE;
有以上存储过程,用Delphi调用时做法为:
dbfrm.DataModule1.OraStoredProc1.StoredProcName:='working.INSERT_SPOT_C_VOICE';
dbfrm.DataModule1.OraStoredProc1.Prepare;
dbfrm.DataModule1.OraStoredProc1.ParamByName('p_Id').AsString:= VarToStr(dbfrm.DataModule1.OraQuery1.FieldValues['spot_id']);;
dbfrm.DataModule1.OraStoredProc1.ParamByName('p_version').AsString:=version;
dbfrm.DataModule1.OraStoredProc1.ParamByName('p_voice').ParamType := ptInput;
dbfrm.DataModule1.OraStoredProc1.ParamByName('p_voice').AsCLOBLocator.LoadFromFile(tmp);
dbfrm.DataModule1.OraStoredProc1.Execute;
请问dbfrm.DataModule1.OraStoredProc1.ParamByName('p_voice').AsCLOBLocator.LoadFromFile(“音频路径”);这一句用c#怎么做啊?