Re: Are you better than...?

On Sun, 29 Jun 2003 13:23:33 -0400, "Brian E Dick" <bdick_at_cox.net> wrote:

> SQL-06553: PLS-306: wrong number or types of arguments in call to
>'XMLCONCAT'
>
>The code runs fine on our Win2K development machines. When comparing the
>spfile's to the two machines, I found two unexpected differences. The Win2K
>machine has Oracle V9.2.0.1.0 running as a MTS. The Unix machine has Oracle
>V9.2.0.2.0 running as a dedicated server.

 Well... the 9.2.0.3 patch set notes has the following as part of the process of applying it:

  3. Drop the xmlconcat function by running the following commands:

      drop public synonym xmlconcat; 
      drop function xmlconcat; 

 The note also includes this in the 'fixed bugs' section:

Bug 2685546 Fixed: 9203
Migration / Upgrade / Downgrade
XMLCONCAT function should be dropped after 9201 -> 9202 upgrade Workaround:
  Manually drop the xmlconcat function

--
Andy Hassall (andy@andyh.co.uk) icq(5747695) (http://www.andyh.co.uk)
Space: disk usage analysis tool (http://www.andyhsoftware.co.uk/space)