philzhou

导航

09 2013 档案

ado.net access oracle dataset via store procedure
摘要:使用存储过程返回结果集,并绑定到ado.net对象中在sql server里面是非常直观的。 1: create procedure GetAllRecords 2: as 3: select * from dept;存储过程返回一个结果集,然后通过SqlDataAdapter绑定给DataSet。但是在Oracle里面返回结果集存储过程是不可以这样写的,返回的结果集要通过游标来完成的。首先创建一个包,新建一个应用游标类型 1: create or replace package cust_types is 2: type ref_cursor is ref curso... 阅读全文

posted @ 2013-09-24 18:20 philzhou 阅读(346) 评论(0) 推荐(0) 编辑

I can connect to an FTP site but I can't list or transfer files.
摘要:原文FTP sessions use two network connections:Thecontrol channelis for user authentication and sending commands and ...Thedata channelis for transferring files and directory listings.If you can connect to an FTP server but not transfer files or directory listings, the most likely cause is a blocked dat 阅读全文

posted @ 2013-09-13 17:46 philzhou 阅读(388) 评论(0) 推荐(0) 编辑