execute immediate 动态SQL

DECLARE
  V_SQL            varchar2(4000);
  v_project_id     number;
  v_project_number varchar2(30);
BEGIN
  V_SQL := 'select project_id,segment1 from pa_projects_all where project_id=:1';
  execute immediate V_SQL
    into v_project_id, v_project_number
    --表名不能作为参数传递  where条件可以
    using 84166;--project_id 值   
    dbms_output.put_line('v_project_id：'||v_project_id);
    dbms_output.put_line('v_project_number：'||v_project_number);
  exception
    when others then
    dbms_output.put_line('错误信息：'||sqlerrm);
END;

------------------------------------OUTPUT---------------------------------------------