Oracle : Inserting into nested tables 12 October 2005 at 00:00
INSERT INTO TABLE(
  SELECT p.nested_table
  FROM primary_table p
  WHERE p.user_id.id = 1)
VALUES ('1', 2, 3)
Transforming XSLT with C# 14 October 2005 at 00:00
  XPathDocument xmlDoc = new XPathDocument(Server.MapPath("/Menu.xml"));
  XslTransform xslt = new XslTransform();
  xslt.Load(Server.MapPath("/Menu.xslt"));
  
  Stream str = new MemoryStream();
  XsltArgumentList arguments = new XsltArgumentList();
  xslt.Transform(xmlDoc, arguments, str, null);
  str.Flush();
  str.Position = 0;
  
  using (StreamReader sr = new StreamReader(str))
  {
      string html = sr.ReadToEnd();
      sr.Close();
      return html;
  }
Passing arguments into XSLT transformations with .NET 18 October 2005 at 00:00
If you were using C#, you would add an argument to your transformation with the following code:
  XsltArgumentList arguments = new XsltArgumentList();
  arguments.AddParam("arg_name", "", "arg_value");
  xslt.Transform(xmlDoc, arguments, str, null);

Using the values passed in is simple, all you need to do is declare the parameter and refer to the parameter with the name prefixed with a "$":

  <xsl:param name="arg_name" />

  <xsl:value-of select="$arg_name" />  
Executing oracle functions 18 October 2005 at 00:00
To execute a function with 2 varchar parameters:

  exec dp_package.get_number('ME', 'YOU');

If the function returns a value you need to declare a vriable to store the value before executing. For example, a function that returns a number can be executed with the following commands:

  var x NUMBER;
  EXEC :x:=dp_package.get_number('ME', 'YOU');
  PRINT x;
SWT : Loading images from Jar files 25 October 2005 at 00:00
SWT images are different to standard Java images - but SWT components require them. The following method loads a file from a jar file in the classpath. It assumes there is a static "display" object that already exists.

public Image loadImage(String file) {
  ClassLoader cl = MyApp.class.getClassLoader();
  java.net.URL url = cl.getResource(file);
  try {
    return new Image(display, url.openStream());
  }
  catch (Exception e) {
    e.printStackTrace();
    return null;
  }
}