Oracle : Inserting into nested tables

Created 12 October 2005 00:00
  SELECT p.nested_table
  FROM primary_table p
  WHERE = 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();
  Stream str = new MemoryStream();
  XsltArgumentList arguments = new XsltArgumentList();
  xslt.Transform(xmlDoc, arguments, str, null);
  str.Position = 0;
  using (StreamReader sr = new StreamReader(str))
      string html = sr.ReadToEnd();
      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;