asp.net实现oracle存储过程增删改查示例

表users(id,userName,userPass,userEmail,createTime) //======================================================== create or replace package package_test as type Test_Cursor is ref cursor; end package_test; //添加用户存储过程:========================================pro_add_user create or replace procedure pro_add_user ( username in users.USERNAME%type, userpass in users.USERPASS%type, useremail in users.USEREMAIL%type, createtime in users.CREATETIME%type ) as begin insert into users (userName,userPass,userEmail,createTime) values (username,userpass,useremail,createtime); end pro_add_user; //删除用户存储过程:=======================================pro_delete_user create or replace procedure pro_delete_user ( user_id in users.ID%type ) as begin delete from users where id=user_id; end pro_delete_user; //批量删除用户存储过程:===================================pro_delete_user_list create or replace procedure pro_delete_user_list ( idlist in varchar2 ) as begin delete from users where id in ('+idlist+'); end pro_delete_user_list; //获取用户列表存储过程:===================================pro_get_user_list create or replace procedure pro_get_user_list ( p_cursor out Package_Test.Test_Cursor ) as begin open p_cursor for select * from users ; end pro_get_user_list; //获取用户模型存储过程:===================================pro_get_user_model create or replace procedure pro_get_user_model ( p_cursor out Package_Test.Test_Cursor, user_id in users.ID%type ) as begin open p_cursor for select * from users where id=user_id; end pro_get_user_model; //更新用户存储过程:========================================pro_update_user create or replace procedure pro_update_user ( user_id in number , username in varchar2 , userpass in varchar2 , useremail in varchar2 , createtime in varchar2 ) as begin update users set userName=username,userPass=userpass,userEmail=useremail,createTime=createtime where id=user_id; end pro_update_user;