<?xml version="1.0" encoding="utf-8"?>
<rss version="2.0"
	xmlns:content="http://purl.org/rss/1.0/modules/content/"
	xmlns:wfw="http://wellformedweb.org/CommentAPI/"
	xmlns:dc="http://purl.org/dc/elements/1.1/"
	xmlns:atom="http://www.w3.org/2005/Atom"
	>

<channel>
	<title>Rik Garner</title>
	<atom:link href="http://www.rikgarner.co.uk/wordpress/?feed=rss2" rel="self" type="application/rss+xml" />
	<link>http://www.rikgarner.co.uk/wordpress</link>
	<description>babblings!</description>
	<pubDate>Mon, 07 Jul 2008 10:58:48 +0000</pubDate>
	<generator>http://wordpress.org/?v=2.6.2</generator>
	<language>en</language>
			<item>
		<title>What&#8217;s a dev to do?</title>
		<link>http://www.rikgarner.co.uk/wordpress/?p=23</link>
		<comments>http://www.rikgarner.co.uk/wordpress/?p=23#comments</comments>
		<pubDate>Mon, 07 Jul 2008 10:58:48 +0000</pubDate>
		<dc:creator>site admin</dc:creator>
		
		<category><![CDATA[Development]]></category>

		<guid isPermaLink="false">http://www.rikgarner.co.uk/wordpress/?p=23</guid>
		<description><![CDATA[I have been trying to get straight in my head what I want to become proficient at in order to be a useful software developer for the next three years. It&#8217;s proving really difficult. I&#8217;ve always felt that, as a professional working every day cranking out code for real clients on real projects, it is [...]]]></description>
		<wfw:commentRss>http://www.rikgarner.co.uk/wordpress/?feed=rss2&amp;p=23</wfw:commentRss>
		</item>
		<item>
		<title>Accessing procedure parameters with Oracle Odp database block</title>
		<link>http://www.rikgarner.co.uk/wordpress/?p=22</link>
		<comments>http://www.rikgarner.co.uk/wordpress/?p=22#comments</comments>
		<pubDate>Mon, 21 Apr 2008 14:19:16 +0000</pubDate>
		<dc:creator>site admin</dc:creator>
		
		<category><![CDATA[Development]]></category>

		<guid isPermaLink="false">http://www.rikgarner.co.uk/wordpress/?p=22</guid>
		<description><![CDATA[The particularly astute among you will have noticed that we have been accessing parameters directly in the code I posted. Really we should be using the Set and Get methods that the database object provides. So instead of:


Database db = DatabaseFactory.CreateDatabase();
DbCommand dbCmd = db.GetStoredProcCommand("AUTH_LOGIN");
db.DiscoverParameters(dbCmd);
DbParameterCollection cmdParams = dbCmd.Parameters;
cmdParams["P_OSNAME"].Value = criteria.Username;
cmdParams["P_INCOMING_PASSWORD"].Value = criteria.Password;
db.ExecuteNonQuery(dbCmd);
authenticationReturnCode =
Convert.ToInt32(db.GetParameterValue(dbCmd, "P_RET_CODE"));

do


db.SetParameterValue(dbCmd, "P_OSNAME", criteria.Username);


and


authenticationReturnCode [...]]]></description>
		<wfw:commentRss>http://www.rikgarner.co.uk/wordpress/?feed=rss2&amp;p=22</wfw:commentRss>
		</item>
		<item>
		<title>EntLib Data Access block with Oracle Odp OUT parameters</title>
		<link>http://www.rikgarner.co.uk/wordpress/?p=21</link>
		<comments>http://www.rikgarner.co.uk/wordpress/?p=21#comments</comments>
		<pubDate>Fri, 18 Apr 2008 14:08:22 +0000</pubDate>
		<dc:creator>site admin</dc:creator>
		
		<category><![CDATA[Development]]></category>

		<guid isPermaLink="false">http://www.rikgarner.co.uk/wordpress/?p=21</guid>
		<description><![CDATA[My code has been failing when getting values out of procedures when I switch from the Microsoft provider to the Odp provider inside the Data Access App Block.
Here is some typical code:


Database db = DatabaseFactory.CreateDatabase();
DbCommand dbCmd = db.GetStoredProcCommand("AUTH_LOGIN");
db.DiscoverParameters(dbCmd);
DbParameterCollection cmdParams = dbCmd.Parameters;
cmdParams["P_OSNAME"].Value = criteria.Username;
cmdParams["P_INCOMING_PASSWORD"].Value = criteria.Password;
db.ExecuteNonQuery(dbCmd);
authenticationReturnCode =
Convert.ToInt32(db.GetParameterValue(dbCmd, "P_RET_CODE"));


This doesn&#8217;t work - it fails with an exception:
Unable [...]]]></description>
		<wfw:commentRss>http://www.rikgarner.co.uk/wordpress/?feed=rss2&amp;p=21</wfw:commentRss>
		</item>
		<item>
		<title>Adapting the DAAB to use Oracle ODP.Net provider</title>
		<link>http://www.rikgarner.co.uk/wordpress/?p=20</link>
		<comments>http://www.rikgarner.co.uk/wordpress/?p=20#comments</comments>
		<pubDate>Tue, 15 Apr 2008 14:36:13 +0000</pubDate>
		<dc:creator>site admin</dc:creator>
		
		<category><![CDATA[Development]]></category>

		<guid isPermaLink="false">http://www.rikgarner.co.uk/wordpress/?p=20</guid>
		<description><![CDATA[I&#8217;ve been doing a bit of tweaking of the Data Access Application Block to try and get around the problem described earlier.
I&#8217;ve replicated OracleDatabase, OracleDataReaderWrapper and the OracleDatabaseAssembler to reference the Odp provider (Oracle.DataAccess) rather than System.Data.OracleClient. I&#8217;ve called these classes OracleOdpDatabase etc. Inside them are some simple changes to enumeration values and data types [...]]]></description>
		<wfw:commentRss>http://www.rikgarner.co.uk/wordpress/?feed=rss2&amp;p=20</wfw:commentRss>
		</item>
		<item>
		<title>Oracle CLOB&#8217;s and the MS Data Access Application Block</title>
		<link>http://www.rikgarner.co.uk/wordpress/?p=19</link>
		<comments>http://www.rikgarner.co.uk/wordpress/?p=19#comments</comments>
		<pubDate>Wed, 09 Apr 2008 14:42:27 +0000</pubDate>
		<dc:creator>site admin</dc:creator>
		
		<category><![CDATA[Development]]></category>

		<guid isPermaLink="false">http://www.rikgarner.co.uk/wordpress/?p=19</guid>
		<description><![CDATA[We have hit upon a problem with the Microsoft Data Access Application Block when trying to update / insert to an Oracle CLOB column; in short it doesn&#8217;t work.
In long: it seems to work until the total size of the data you are passing to the procedure is over ~32k. This actually seems to be [...]]]></description>
		<wfw:commentRss>http://www.rikgarner.co.uk/wordpress/?feed=rss2&amp;p=19</wfw:commentRss>
		</item>
		<item>
		<title>Earthquake</title>
		<link>http://www.rikgarner.co.uk/wordpress/?p=18</link>
		<comments>http://www.rikgarner.co.uk/wordpress/?p=18#comments</comments>
		<pubDate>Wed, 27 Feb 2008 09:56:03 +0000</pubDate>
		<dc:creator>site admin</dc:creator>
		
		<category><![CDATA[General]]></category>

		<guid isPermaLink="false">http://www.rikgarner.co.uk/wordpress/?p=18</guid>
		<description><![CDATA[We had an earthquake last night - I was working upstairs on the PC when house began to shake.
It woke my wife up, but luckily not the kids.
As soon as it was over I wrote down this account:
&#8220;5 to 1. At first sounded like a very strong gust of wind. Then noticed the desk was [...]]]></description>
		<wfw:commentRss>http://www.rikgarner.co.uk/wordpress/?feed=rss2&amp;p=18</wfw:commentRss>
		</item>
		<item>
		<title>Change of theme - change in general</title>
		<link>http://www.rikgarner.co.uk/wordpress/?p=17</link>
		<comments>http://www.rikgarner.co.uk/wordpress/?p=17#comments</comments>
		<pubDate>Thu, 04 Oct 2007 23:22:12 +0000</pubDate>
		<dc:creator>site admin</dc:creator>
		
		<category><![CDATA[General]]></category>

		<guid isPermaLink="false">http://www.rikgarner.co.uk/wordpress/?p=17</guid>
		<description><![CDATA[I thought it was about time that I had a bit of a revamp around here, so I upgraded a couple of weeks ago and decided to try out a new theme.
Lots of stuff has happened in the last six months; our daughter arrived, which has soaked up lots of time and I&#8217;m working like [...]]]></description>
		<wfw:commentRss>http://www.rikgarner.co.uk/wordpress/?feed=rss2&amp;p=17</wfw:commentRss>
		</item>
		<item>
		<title>Preventing the designer setting properties of a User Control</title>
		<link>http://www.rikgarner.co.uk/wordpress/?p=16</link>
		<comments>http://www.rikgarner.co.uk/wordpress/?p=16#comments</comments>
		<pubDate>Wed, 04 Jul 2007 15:03:02 +0000</pubDate>
		<dc:creator>site admin</dc:creator>
		
		<category><![CDATA[Development]]></category>

		<guid isPermaLink="false">http://www.rikgarner.co.uk/wordpress/?p=16</guid>
		<description><![CDATA[I&#8217;ve built a couple of user controls to simplify some data capture in our current application, one of which is a date choosing control. It exposes a couple of fields exposed as properties that should only be used by code and not accessible through the design-time property grid. I quickly discovered the decoration [Browsable(false)] to [...]]]></description>
		<wfw:commentRss>http://www.rikgarner.co.uk/wordpress/?feed=rss2&amp;p=16</wfw:commentRss>
		</item>
		<item>
		<title>Finding the deepest node in some XML using XPath</title>
		<link>http://www.rikgarner.co.uk/wordpress/?p=15</link>
		<comments>http://www.rikgarner.co.uk/wordpress/?p=15#comments</comments>
		<pubDate>Tue, 22 Aug 2006 12:33:36 +0000</pubDate>
		<dc:creator>site admin</dc:creator>
		
		<category><![CDATA[Development]]></category>

		<guid isPermaLink="false">http://www.rikgarner.co.uk/wordpress/?p=15</guid>
		<description><![CDATA[Today&#8217;s problem was, given a set of XML nodes or arbitrary depth, how do I find the deepest node quickly.  I have an XML description of a hierarchy of folders in a document respository.  It consists of a series of Location elements, each with one or more children.
After quite a bit of pootling [...]]]></description>
		<wfw:commentRss>http://www.rikgarner.co.uk/wordpress/?feed=rss2&amp;p=15</wfw:commentRss>
		</item>
		<item>
		<title>Customer service at Compman.co.uk</title>
		<link>http://www.rikgarner.co.uk/wordpress/?p=13</link>
		<comments>http://www.rikgarner.co.uk/wordpress/?p=13#comments</comments>
		<pubDate>Wed, 22 Mar 2006 13:23:50 +0000</pubDate>
		<dc:creator>site admin</dc:creator>
		
		<category><![CDATA[General]]></category>

		<guid isPermaLink="false">http://www.rikgarner.co.uk/wordpress/?p=13</guid>
		<description><![CDATA[For some time now I have been ordering my computer books from Computer Manuals - a UK based on-line retailer. Apart from being very reasonably priced, their big advantage was that they only sold computer books, so, if I needed to find something quickly, I could just type the author&#8217;s surname into the search box [...]]]></description>
		<wfw:commentRss>http://www.rikgarner.co.uk/wordpress/?feed=rss2&amp;p=13</wfw:commentRss>
		</item>
	</channel>
</rss>
