摘要: --创建包create or replace package pac_stuas type cur_stu is ref cursor; procedure getStu(i in number,cur_stu out cur_stu);end pac_stu;--创建包体create or replace package body pac_stuasprocedure getStu(i in number,cur_stu out cur_stu) as nums number(10); begin select count(*) into nums from stu; if nums... 阅读全文
posted @ 2013-07-28 23:55 roscee 阅读(1570) 评论(0) 推荐(0) 编辑
摘要: create procedure proc_1 asbegin dbms_output.put_line('hello boy ');end proc_1;--set serveroutput on; exec proc_1;create or replace procedure proc_2(v_1 in varchar2,v_2 out varchar2)asbegin v_2:='hello ' || v_1;end proc_2;/*declare v_2 varchar2(100);begin proc_2('boy',v_2); db 阅读全文
posted @ 2013-07-28 18:19 roscee 阅读(187) 评论(0) 推荐(0) 编辑
摘要: 转自:http://blog.sina.com.cn/s/blog_477252210100a7l4.html1、使用org.codehaus.xfire.spring.XFireSpringServlet与ServiceBean1.1 web.xml的配置contextConfigLocationclasspath:applicationContext-webservice.xmlorg.springframework.web.util.Log4jConfigListenerorg.springframework.web.context.ContextLoaderListenerXFireS 阅读全文
posted @ 2013-07-28 00:58 roscee 阅读(1029) 评论(0) 推荐(0) 编辑