My Developer Memo

declare
    w_sql varchar2(100);
    w_return integer;
    w_cursor integer;

begin
    w_sql := 'select * from customer';
    w_cursor := dbms_sql.open_cursor;
    dbms_sql.parse(w_cursor,w_sql,dbms_sql.native);
    w_return := dbms_sql.execute(w_cursor);
end;