It's 13:15 (+0500) Sunday.

On Friday, I was trying to rollout the our project's latest schema build on
a Unix server. Unfortunately, some new XML DB code is breaking the build
with the following error.

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.

I have searched Google and AskTom for this error without success. It's the
weekend so my support staff is unavailable. And my support staff has the
MetaLink account.

So, unless you can help, I'm at a standstill until tomorrow. Thanks to
anyone and everyone that can assist.

Here is sqlplus session output that demonstrates the error.

NT working. ***

SQL*Plus: Release 9.2.0.1.0 - Production on Sun Jun 29 12:42:21 2003

Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.


Connected to:
Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.1.0 - Production

SQL> create table foo(c1 number, c2 varchar2(30));

Table created.

SQL> insert into foo values(1,'A');

1 row created.

SQL> commit;

Commit complete.

SQL> select xmlelement("c1", c1) from foo;

XMLELEMENT("C1",C1)
----------------------------------------------------------------------------
----
<c1>1</c1>

SQL> select xmlelement("c2", c2) from foo;

XMLELEMENT("C2",C2)
----------------------------------------------------------------------------
----
<c2>A</c2>

SQL> select xmlconcat(xmlelement("c1",c1),xmlelement("c2",c2)) from foo;

XMLCONCAT(XMLELEMENT("C1",C1),XMLELEMENT("C2",C2))
----------------------------------------------------------------------------
----
<c1>1</c1>
<c2>A</c2>


SQL>
*********

Unix not working. ***

SQL*Plus: Release 9.2.0.2.0 - Production on Sun Jun 29 12:13:33 2003

Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.


Connected to:
Oracle9i Enterprise Edition Release 9.2.0.2.0 - 64bit Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.2.0 - Production
SQL> create table foo(c1 number, c2 varchar2(30));

Table created.

SQL> insert into foo values(1,'A');

1 row created.

SQL> commit;

Commit complete.

SQL> select xmlelement("c1", c1) from foo;

XMLELEMENT("C1",C1)
----------------------------------------------------------------------------
----
<c1>1</c1>

SQL> select xmlelement("c2", c2) from foo;

XMLELEMENT("C2",C2)
----------------------------------------------------------------------------
----
<c2>A</c2>

SQL> select xmlconcat(xmlelement("c1",c1),xmlelement("c2",c2)) from foo;
select xmlconcat(xmlelement("c1",c1),xmlelement("c2",c2)) from foo
*
ERROR at line 1:
SQL-06553: PLS-306: wrong number or types of arguments in call to
'XMLCONCAT'

SQL>
**********

On Sun, 29 Jun 2003 13:23:33 -0400, "Brian E Dick" <bdick@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)

On Sun, 29 Jun 2003 17:41:49 -0400, "Brian E Dick" <bdick@cox.net> wrote:

>Sounds promising. What is the current version/patch level for 9i? Any
>recommendations for which version we should be using (not 9.2.0.2.0
>obviously)?

9.2.0.3 is the latest. It also comes with a note to the effect that it's the
minimum level for using the XML DB functions (at least, that's what it looks
like it says):

"XML DB
XDB 9.2.0.3 is a mandatory patch level for this product. "

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

That pretty much settles it then.

"Andy Hassall" <andy@andyh.co.uk> wrote in message
news:feoufv01qu4plofi5a6sh3roiodh6bju8d@4ax.com...
> On Sun, 29 Jun 2003 17:41:49 -0400, "Brian E Dick" <bdick@cox.net> wrote:
>
> >Sounds promising. What is the current version/patch level for 9i? Any
> >recommendations for which version we should be using (not 9.2.0.2.0
> >obviously)?
>
> 9.2.0.3 is the latest. It also comes with a note to the effect that it's
the
> minimum level for using the XML DB functions (at least, that's what it
looks
> like it says):
>
> "XML DB
> XDB 9.2.0.3 is a mandatory patch level for this product. "
>
> --
> Andy Hassall (andy@andyh.co.uk) icq(5747695) (http://www.andyh.co.uk)
> Space: disk usage analysis tool (http://www.andyhsoftware.co.uk/space)

"Brian E Dick" <bdick@cox.net> wrote in message news:<y2JLa.27958$ZE.3088@lakeread05>...
> Also, I forgot to note that I don't know what version of Unix I'm using.
> This is the first time I've had to use this particular Unix machine, and the
> system admin has changed the logon banner.

I know this is too late, but uname -a is the general way. If you have
root access, dmesg is often informative.

jg
--
@home.com is bogus.
http://www.signonsandiego.com/news/u...1b1oracle.html