Weblog

28/2: London Developer Co-op

Last year my company Inter Weavers went into partnership with three other companies and the London Developer Co-op (or LDC for short) was created.  LDC has since grown to six partners.  My initial reasons for teaming up with other companies was one of resourcing.  I was in a position where I was in danger of having too much on my plate but didn't want to turn work away.  However, it also gives us the opportunity to bid for larger projects with wider technical scope and we are already having some success in that direction.

And here's one of my favourite tracks from the 80s ...
Author: Rob Wills Categories:  LDC Lotus Notes Domino 
0 Comment(s) 

25/2: Shrovetide football @ Ashbourne

Yesterday and today was Ashbourne's annual football event.  It is basically football before they invented the whistle.  Ronaldo or Drogba wouldn't last two minutes in that scrum.  Take a look!

Author: Rob Wills Categories:  Shrovetide  Football 
0 Comment(s) 

24/2: Calling Oracle Stored Procedures from Lotus Notes or Domino

I am currently writing an application for one of my clients that creates new projects in the Oracle eBusiness Suite ERP from the Lotus Notes client.  Oracle have public APIs written in PL/SQL that you must use for the task.  I created a PL/SQL "wrapper program" to call the APIs and called this as a stored procedure.

When this application is complete, I plan to write an in depth article on the techniques I used.

However, in the meantime, I thought it was worth posting the syntax that I used to call the stored procedure with both input and output parameters.  The documentation for calling a stored procedure is a little sparse.

So here is an example stored procedure.  You could call that using an anonymous block like so.  The LotusScript code to call that stored procedure using the LC LSX is here.

Finally, I used an on-line book to learn the fundamentals of PL/SQL which you can find here.  I plan to buy that book because I'll be using Pl/SQL again.
Author: Rob Wills Categories:  Oracle  Domino  LC LSX  Stored Procedures 
0 Comment(s) 

20/2: Upgrading to Windows2000!

No not the Operating System; we're having new windows at home and the company is called Windows 2000 Limited!  It probably seemed like a good idea at the time but now instead of the futuristic appeal that it once had, the name is kind of dated and makes you think of second rate operating systems.  Still, they could have called it Windows Millennium I suppose which would have been worse.

Seriously the quality of the windows and doors, the price and the attention to detail of the fitter are first rate so if you live anywhere near Ripley in Derbyshire where they are based, I highly recommend them.

They are also providing a large conservatory but we have to wait for planning permission with that one.
Author: Robin Wills Categories:  Windows 
0 Comment(s) 

11/2: I’m back!

Thirteen months ago, I had some minor issues with my blog template when I upgraded to Notes 8.  What I should have done was upgrade my template to the version that Steve Castledine had brought with him to IBM which was now an official Notes template but instead I procrastinated - and stopped posting.

This is not an apology.  I'm not sure anyone noticed really.

But I've now upgraded my blog and intend to post more frequently.  It took all of 10 minutes to upgrade and I wish I'd done it earlier.  Thank you Steve for providing an agent that converted my HTML theme so that it worked in the new template.

What's happened in the last thirteen months?

Well quite a lot really and I'll be posting about some of that.  On the personal front, Julie and I decided to get married after a whirlwind 17 year romance!  My company is one of the founding partners within the London Developer Coop, or LDC for short.  That will help all of us to resource our bigger projects better and to take on bigger projects jointly which is quite exciting.  I also went to my first ever Lotusphere last month which was a real eye opener.  Inter Weavers has joined the Lotus Notes/Domino Design Partner Programme and has become a Lotus Foundations Business Partner.  I've also been working hard implementing Oracle ERP for a client and integrating it with Lotus Notes and Domino using PL/SQL and the Oracle APIs.  The world has also gone into financial meltdown whilst I've been away.

So plenty to blog about; Planet Lotus here I come ...
Author: Robin Wills Categories:
2 Comment(s)