Oracle : Inserting into nested tables
Created 12 October 2005 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#
Created 14 October 2005 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
Created 18 October 2005 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
Created 18 October 2005 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;