Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

"OCI-21560: argument 4 is null, invalid, or out of range"

Subir DuttaDec 22 2010 — edited Dec 22 2010
Hi,

When I am running query *"select xmlelement("SQLX", 'Hello World!') from dual"* in Toad , i am getting below error -
*"OCI-21560: argument 4 is null, invalid, or out of range"*

In sql prompt also it is not runnig.Got below error.
------------------------------------------------------------------
SQL> select xmlelement("SQLX", 'Hello World!') from dual
2 /
select xmlelement("SQLX", 'Hello World!') from dual
*
ERROR at line 1:
ORA-03113: end-of-file on communication channel


SQL>
-----------------------------------------------------------------------------------------------
DB version -
BANNER
--------------------------------------------------------------------------------
Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - 64bit Production
PL/SQL Release 11.1.0.7.0 - Production
CORE 11.1.0.7.0 Production
TNS for HPUX: Version 11.1.0.7.0 - Production
NLSRTL Version 11.1.0.7.0 - Production

Please let me know the solution.

Rg.
Subir
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jan 19 2011
Added on Dec 22 2010
2 comments
870 views