ora-0095 缺失关键字
目的:
select count(1) into v_count2 from ne_job j where j.job_id in ( v_job_id_str )
修改后执行成功
sql_str:=' select count(1) from ne_job j where j.job_id in ( '||v_job_id_str||' ) ';
dbms_output.put_line('-0000-'||sql_str );
execute immediate sql_str into v_count2 ;
dbms_output.put_line('-2222-'||v_count2 );