declare
PaID VARCHAR2(10) ;
strPaInfo_ VARCHAR2(500) ;
InsertSQLStr VARCHAR2(1024);
begin
strPaInfo_:='\"ffd\",0,1,1,1,6,0';--这是客户端传过来的形式
select clinic.S_61_1_PATIENTINFO_TABLE.nextval into paID
from dual;
insert into clinic.patientInfo_table (paID,paName, paSexID, MarryInfoID, WorkInfoID, paNationID,NativeInfoID, BloodInfoID, rate) values ( paID ,strPaInfo_, 100);--此处值不够
end;
PaID VARCHAR2(10) ;
strPaInfo_ VARCHAR2(500) ;
InsertSQLStr VARCHAR2(1024);
begin
strPaInfo_:='\"ffd\",0,1,1,1,6,0';--这是客户端传过来的形式
select clinic.S_61_1_PATIENTINFO_TABLE.nextval into paID
from dual;
insert into clinic.patientInfo_table (paID,paName, paSexID, MarryInfoID, WorkInfoID, paNationID,NativeInfoID, BloodInfoID, rate) values ( paID ,strPaInfo_, 100);--此处值不够
end;
我的意思是实现这样的效果
insert into clinic.patientInfo_table (paID,paName, paSexID, MarryInfoID, WorkInfoID, paNationID,NativeInfoID, BloodInfoID, rate) values ( paID ,'ffd',0,1,1,1,6,0,100);
insert into clinic.patientInfo_table (paID,paName, paSexID, MarryInfoID, WorkInfoID, paNationID,NativeInfoID, BloodInfoID, rate) values ( paID ,'ffd',0,1,1,1,6,0,100);
这样一个语句存在InsertSQLStr 中
然后执行之。
这就可以了,你想问什么,不太明白。