| 发表于:2007-07-03 13:48:48 楼主 |
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#怎么做啊? |
|
|
|
|