--oracle database for programming development--stored procedures using dynamic parameter bindings (3)

1, dynamic parameter binding, can realize the dynamic execution of different SQL

-- Create a package Create or Replace  as is cursor;        procedure inch  Number , emplist out empcursor); END MyPackage;

--Create a package bodyCreate or ReplacePackage BODY MyPackage as  procedureQueryemplist (DNOinch  Number, emplist out Empcursor) asStr_l_selectsqlvarchar2(4000); BEGINStr_l_selectsql:='SELECT * from emp where deptno =:d no'; --EXECUTE IMMEDIATE str_l_selectsql USING v_2;--cannot implement dynamic binding parameters    --str_l_selectsql: =str_l_selectsql | | dno;--can be stitched in SQL way, but not professionally    --open emplist for str_l_selectsql;    --with the cursor, you first open the cursor    OpenEmplist forStr_l_selectsql USING DNO;--Dynamic Binding Parameters        NULL; ENDqueryemplist;ENDMyPackage;

--oracle database for programming development--stored procedures using dynamic parameter bindings (3)