Are you better than...?

From: Brian E Dick <bdick_at_cox.net>
Date: Sun, 29 Jun 2003 13:23:33 -0400
Message-ID: <qgFLa.26520$ZE.8361@lakeread05>

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

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

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));