首页 > Windows开发 > 详细

c# 调用存储过程

时间:2016-08-12 18:17:08      阅读:241      评论:0      收藏:0      [点我收藏+]

 

//创建存储过程

create or replace procedure nvduser1_ais.p1_delete_tables
as
begin
EXECUTE IMMEDIATE ‘TRUNCATE TABLE vor‘;
EXECUTE IMMEDIATE ‘TRUNCATE TABLE DESIGNATED_POINT‘;
EXECUTE IMMEDIATE ‘TRUNCATE TABLE SIGNIFICANT_POINT‘;
EXECUTE IMMEDIATE ‘TRUNCATE TABLE RTE_SEG‘;
EXECUTE IMMEDIATE ‘TRUNCATE TABLE EN_ROUTE_RTE‘;
EXECUTE IMMEDIATE ‘TRUNCATE TABLE SEGMENT‘;
EXECUTE IMMEDIATE ‘TRUNCATE TABLE SID‘;
EXECUTE IMMEDIATE ‘TRUNCATE TABLE IAP‘;
EXECUTE IMMEDIATE ‘TRUNCATE TABLE PROCEDURE_LEG‘;
EXECUTE IMMEDIATE ‘TRUNCATE TABLE AIRSPACE‘;
EXECUTE IMMEDIATE ‘TRUNCATE TABLE GEO_BORDER‘;
EXECUTE IMMEDIATE ‘TRUNCATE TABLE GEO_BORDER_VERTEX‘;
EXECUTE IMMEDIATE ‘TRUNCATE TABLE EV_EN_COMM‘;
EXECUTE IMMEDIATE ‘TRUNCATE TABLE PV_AIRPORT_COMM‘;
EXECUTE IMMEDIATE ‘TRUNCATE TABLE ILS_CAT‘;
EXECUTE IMMEDIATE ‘TRUNCATE TABLE TAKEOFF‘;
EXECUTE IMMEDIATE ‘TRUNCATE TABLE LANDSTANDARD_DETAILS‘;
EXECUTE IMMEDIATE ‘TRUNCATE TABLE LANDSTANDARD‘;
EXECUTE IMMEDIATE ‘TRUNCATE TABLE OBSTACLE‘;
EXECUTE IMMEDIATE ‘TRUNCATE TABLE COMPANY_RTE‘;
END;

//如果登陆用户和存储过程不在同一个用户下,需要给登陆用户赋予直行存储过程的权限
//否则不需要

//grant execute on P2_DELETE_TABLES to ais_admin; 

 

存储过程使用truncate时  EXECUTE IMMEDIATE ‘TRUNCATE TABLE COMPANY_RTE‘;  这样写即可

 

c# 调用存储过程

原文:http://www.cnblogs.com/houzf/p/5765768.html

(0)
(0)
   
举报
评论 一句话评论(0
关于我们 - 联系我们 - 留言反馈 - 联系我们:wmxa8@hotmail.com
© 2014 bubuko.com 版权所有
打开技术之扣,分享程序人生!