C# µ÷ÓÃOracle ´æ´¢¹ý³Ì·µ»ØÊý¾Ý¼¯ ʵÀý
1. ÔÚoracle Ï´´½¨±í
t_user(
ID varchar(20),
Name varchar(20)
)
2. Ìí¼ÓÊý¾Ý
'1' , 'ÕÅÈý'
'2' , 'ÀîËÄ'
3. ´´½¨°ü²¢ÇÒ¶¨Òå±äÁ¿ºÍÉùÃ÷´æ´¢¹ý³Ì
CREATE OR REPLACE PACKAGE pkg_user AS
--¶¨Òå·µ»ØÖµ£¨ÓαêÀàÐÍ£©
TYPE myrctype IS REF CURSOR;
--¶¨Òå²éѯ¹ý³Ì
PROCEDURE sp_userlist (cur_result OUT myrctype);
END pkg_user;
4.´´½¨´æ´¢¹ý³Ì sp_userlist
CREATE OR REPLACE PACKAGE BODY "PKG_USER" AS
--²éѯ¹ý³Ì
PROCEDURE sp_userlist(cur_result OUT myrctype)
IS
sqlstr VARCHAR2 (500);
BEGIN
OPEN cur_result FOR
select * from t_user ;
END sp_userlist ;
END pkg_user;
5. C# ÖоͿÉÒÔµ÷ÓÃÕâ¸ö´æ´¢¹ý³ÌÁË.
ÔÚOracle helper ÖÐÌí¼Ó
public static void RunSql(string SqlString, CommandType cmdType, out DataTable dt)
{
OracleCommand cmd = CreateSqlCommand(SqlString, cmdType);
OracleDataAdapter da;
&n
Ïà¹ØÎĵµ£º
Welcome to Microsoft Developer Support, Languages team blog! You will find a lot of language related troubleshooting resources here.
Troubleshooting PInvoke Related Issues
I am back with some more PInvoke Stuff. Recently I was working on a PInvoke issue which I found interesting ......
--Ãû´Ê˵Ã÷£ºÔ´——±»Í¬²½µÄÊý¾Ý¿â
-- Ä¿µÄ——Ҫͬ²½µ½µÄÊý¾Ý¿â
/*Ò»¡¢´´½¨dblink£º*/
--1¡¢ÔÚÄ¿µÄÊý¾Ý¿âÉÏ£¬´´½¨dblin
drop database link dblink_anson;
Create public
database link dblink_an ......
Oracle Flashback Technology
Oracle Flashback Technology reduces recovery time from hours to minutes.
from: http://www.oracle.com/technology/deploy/availability/htdocs/Flashback_Overview.htm
According to many studies, 40% of application outages are caused by operator or user errors. Part of be ......
Èç¹û²»ÊÇÒòΪÕâ´Î»»hisµÄ·þÎñÆ÷£¬¹À¼ÆÎÒÒ»Ö±Ò²²»»áÓöµ½Õâ¸öÎÊÌ⣬һֱ¾õµÃoracleºÜ¸ßÉ¶ÔËüҲûÓÐÑо¿£¬¿ÉÕâ´Î»»·þÎñÆ÷£¬Æ«Æ«ÈÃÎÒÓöµ½ÁËÒ»¸öÎÊÌ⣬ÕÛÄ¥ÁËÕûÕûÁ½Ì죬ÖÕÓÚÔÚ×òÌì½â¾öµôÁË£¬¼Ç¼ÏÂÀ´£¬ÒÔ±¸ÒÔºóËùÓá£
ÖÜÎåÍíÉÏ»»ÁË·þÎñÆ÷£¬ÖÜÒ»ÔçÉÏ·¢ÏÖ³¬ÉùµÄ¹¤×÷Õ ......