这句存储过程里的sql语句哪错了?说我引号内的字符串没有正确结束
insert_sqlStr := 'insert into tempTable_rangeTest select
pa.CN_ID,
pa.CR_PERIOD_START,
pa.CR_PERIOD_END,
'''||programId||''',
from TN_PERIOD_RANGE pa
where pa.CR_PERIOD_START = '''||onePeriodId||'';
insert_sqlStr := 'insert into tempTable_rangeTest select
pa.CN_ID,
pa.CR_PERIOD_START,
pa.CR_PERIOD_END,
'''||programId||''',
from TN_PERIOD_RANGE pa
where pa.CR_PERIOD_START = '''||onePeriodId||'';
pa.CN_ID,
pa.CR_PERIOD_START,
pa.CR_PERIOD_END,
'''||programId||''',
from TN_PERIOD_RANGE pa
where pa.CR_PERIOD_START = '''||onePeriodId||''';末尾少个引号
pa.CN_ID,
pa.CR_PERIOD_START,
pa.CR_PERIOD_END,
'''||programId||'''
from TN_PERIOD_RANGE pa
where pa.CR_PERIOD_START = '''||onePeriodId||'''';
insert into tempTable_rangeTest select
pa.CN_ID,
pa.CR_PERIOD_START,
pa.CR_PERIOD_END,
programId,
from TN_PERIOD_RANGE pa
where pa.CR_PERIOD_START = onePeriodId;
注意变量名不与字段名重复即可