动态sql不解问题!
create or replace procedure insert_data
(in_id in yesong_table_1.id%type,
in_name in yesong_table_1.name%type,
in_age in yesong_table_1.age%type )
is
l_handle integer;
l_sql_stmt varchar2(100);
l_rows_processed binary_integer;
begin
l_sql_stmt :='insert into yesong_table_1 values (:id,:name,:age);';
l_handle :=dbms_sql.open_cursor;
dbms_sql.parse(l_handle,l_sql_stmt,dbms_sql.native);
dbms_sql.bind_variable(l_handle,':id',in_id);
dbms_sql.bind_variable(l_handle,':name',in_name);
dbms_sql.bind_variable(l_handle,':age',in_age);
l_rows_processed :=dbms_sql.execute(l_handle);
dbms_sql.close_cursor(l_handle);
end;
为什么没有结果,不起作用,虽然通过编译,怎么执行?