Mon, 16 Nov 2009 08:53:00 GMTCSDN博客聚合服务http://blog.csdn.net/blogrss.aspx?username=garefieldhttp://blog.csdn.net/garefield/archive/2009/11/16/4816713.aspx<br /> 数组及对象定义如下：<br />create or replace type t_test as object (value number(9));<br />create or replace type t_testarr as table of  t_test;<br />存储过程：<br />procedure pro_test(testval in t_testarr )<br />PL/SQL develop下:<br />declare<br />  valt_testarr;<br />begin<br />  val:=t_testarr(t_test (10),t_test (11),t_test (12),t_test(13));<br />  execute immediate 'call pro_test (:val)'using val;<br />  commit;<br />end;<br />delphi下使用odac控件：<br />  with OraQuery1 do<br />  begin<br />    close;<img src="http://www1.feedsky.com/t1/297367631/garefield/csdn.net/s.gif?r=http://blog.csdn.net/garefield/archive/2009/11/16/4816713.aspx" border="0" height="0" width="0" style="position:absolute" /><p class="fswww1"><a href="http://www1.feedsky.com/r/l/csdn.net/garefield/297367631/art01.html" target="_blank"><img border="0" ismap="ismap" src="http://www1.feedsky.com/r/i/csdn.net/garefield/297367631/art01.gif" onerror="this.style.display='none'" /></a></p>Mon, 16 Nov 2009 16:53:00 +0800garefieldhttp://blog.csdn.net/garefield/archive/2009/11/16/4816713.aspxgarefieldhttp://blog.csdn.net/garefield/archive/2009/11/16/4816713.aspxhttp://blog.csdn.net/garefield/rss.aspxcsdn.net/garefield/~5966276/297367631/4073524http://blog.csdn.net/garefield/archive/2007/10/21/1835393.aspxORACLE的事务与SQL server和sybase有很大的不同，它的每一条语句的效果，要么全部实现，要么全部不实现<p class="fswww1"><a href="http://www1.feedsky.com/r/l/csdn.net/garefield/297367632/art01.html" target="_blank"><img border="0" ismap="ismap" src="http://www1.feedsky.com/r/i/csdn.net/garefield/297367632/art01.gif" onerror="this.style.display='none'" /></a></p>Sun, 21 Oct 2007 10:12:00 +0800garefieldhttp://blog.csdn.net/garefield/archive/2007/10/21/1835393.aspxgarefieldhttp://blog.csdn.net/garefield/archive/2007/10/21/1835393.aspxhttp://blog.csdn.net/garefield/rss.aspxcsdn.net/garefield/~5966276/297367632/4073524http://blog.csdn.net/garefield/archive/2007/10/12/1822064.aspx使用程序包、用户数据类型来实现ORACLE的内存表。<p class="fswww1"><a href="http://www1.feedsky.com/r/l/csdn.net/garefield/297367633/art01.html" target="_blank"><img border="0" ismap="ismap" src="http://www1.feedsky.com/r/i/csdn.net/garefield/297367633/art01.gif" onerror="this.style.display='none'" /></a></p>Fri, 12 Oct 2007 16:24:00 +0800garefieldhttp://blog.csdn.net/garefield/archive/2007/10/12/1822064.aspxgarefieldhttp://blog.csdn.net/garefield/archive/2007/10/12/1822064.aspxhttp://blog.csdn.net/garefield/rss.aspxcsdn.net/garefield/~5966276/297367633/4073524http://blog.csdn.net/garefield/archive/2007/10/10/1818572.aspxORACLE的多版本与锁定的问题<p class="fswww1"><a href="http://www1.feedsky.com/r/l/csdn.net/garefield/297367634/art01.html" target="_blank"><img border="0" ismap="ismap" src="http://www1.feedsky.com/r/i/csdn.net/garefield/297367634/art01.gif" onerror="this.style.display='none'" /></a></p>Wed, 10 Oct 2007 15:35:00 +0800garefieldhttp://blog.csdn.net/garefield/archive/2007/10/10/1818572.aspxgarefieldhttp://blog.csdn.net/garefield/archive/2007/10/10/1818572.aspxhttp://blog.csdn.net/garefield/rss.aspxcsdn.net/garefield/~5966276/297367634/4073524http://blog.csdn.net/garefield/archive/2007/10/09/1816707.aspx关于oracle绑定变量的使用<p class="fswww1"><a href="http://www1.feedsky.com/r/l/csdn.net/garefield/297367635/art01.html" target="_blank"><img border="0" ismap="ismap" src="http://www1.feedsky.com/r/i/csdn.net/garefield/297367635/art01.gif" onerror="this.style.display='none'" /></a></p>Tue, 09 Oct 2007 13:36:00 +0800garefieldhttp://blog.csdn.net/garefield/archive/2007/10/09/1816707.aspxgarefieldhttp://blog.csdn.net/garefield/archive/2007/10/09/1816707.aspxhttp://blog.csdn.net/garefield/rss.aspxcsdn.net/garefield/~5966276/297367635/4073524http://blog.csdn.net/garefield/archive/2007/10/06/1813328.aspx示例修改UIC生成的头文件，使其更具有条理。<p class="fswww1"><a href="http://www1.feedsky.com/r/l/csdn.net/garefield/297367636/art01.html" target="_blank"><img border="0" ismap="ismap" src="http://www1.feedsky.com/r/i/csdn.net/garefield/297367636/art01.gif" onerror="this.style.display='none'" /></a></p>Sat, 06 Oct 2007 20:35:00 +0800garefieldhttp://blog.csdn.net/garefield/archive/2007/10/06/1813328.aspxgarefieldhttp://blog.csdn.net/garefield/archive/2007/10/06/1813328.aspxhttp://blog.csdn.net/garefield/rss.aspxcsdn.net/garefield/~5966276/297367636/4073524http://blog.csdn.net/garefield/archive/2007/10/03/1810652.aspx一个QT4创建表单的示例<p class="fswww1"><a href="http://www1.feedsky.com/r/l/csdn.net/garefield/297367637/art01.html" target="_blank"><img border="0" ismap="ismap" src="http://www1.feedsky.com/r/i/csdn.net/garefield/297367637/art01.gif" onerror="this.style.display='none'" /></a></p>Wed, 03 Oct 2007 20:43:00 +0800garefieldhttp://blog.csdn.net/garefield/archive/2007/10/03/1810652.aspxgarefieldhttp://blog.csdn.net/garefield/archive/2007/10/03/1810652.aspxhttp://blog.csdn.net/garefield/rss.aspxcsdn.net/garefield/~5966276/297367637/4073524http://blog.csdn.net/garefield/archive/2007/10/01/1809265.aspxwindows下如何建立Dev-Cpp的QT4开发环江<p class="fswww1"><a href="http://www1.feedsky.com/r/l/csdn.net/garefield/297367638/art01.html" target="_blank"><img border="0" ismap="ismap" src="http://www1.feedsky.com/r/i/csdn.net/garefield/297367638/art01.gif" onerror="this.style.display='none'" /></a></p>Mon, 01 Oct 2007 22:29:00 +0800garefieldhttp://blog.csdn.net/garefield/archive/2007/10/01/1809265.aspxgarefieldhttp://blog.csdn.net/garefield/archive/2007/10/01/1809265.aspxhttp://blog.csdn.net/garefield/rss.aspxcsdn.net/garefield/~5966276/297367638/4073524