Sitemap

Amicuk Programming Answers

OCI-21560 when using XMLElement

-0001-11-30   Views:3

Advertisement

Dear All, I've just made my first step regarding to the XML field, but the following select caused me an error: select XMLElement ("colors", color) from my_colors; OCI-21560: argument 3 is null, invalid, or out of range I was looking for answers

Dear All,
I've just made my first step regarding to the XML field, but the following select caused me an error:
select XMLElement ("colors", color) from my_colors;
OCI-21560: argument 3 is null, invalid, or out of range
I was looking for answers on google and here, but I couldn't find anything usable.
One did tell me, that the reason of the error might be using Oracle version 9.2.0.4, so I patched it to 9.2.0.6, but the problem remained the same...
I do really hope that someone has the solution here and won't hesistate to share it with me! :-)
Thank You!
Franky

The replay answer
Advertisement
Franky,
First of all, show us if you can do a direct select. Like
select color from my_colors;
I was able to do this similar query though:
SQL> conn scott/tiger
Connected.
SQL> select empno from emp;
     EMPNO
      7369
      7499
      7521
      7566
      7654
      7698
      7782
      7788
      7839
      7844
      7876
     EMPNO
      7900
      7902
      7934
14 rows selected.
SQL> select xmlelement("EmpNo", empno) from emp;
XMLELEMENT("EMPNO",EMPNO)
<EmpNo>7369</EmpNo>
<EmpNo>7499</EmpNo>
<EmpNo>7521</EmpNo>
<EmpNo>7566</EmpNo>
<EmpNo>7654</EmpNo>
<EmpNo>7698</EmpNo>
<EmpNo>7782</EmpNo>
<EmpNo>7788</EmpNo>
<EmpNo>7839</EmpNo>
<EmpNo>7844</EmpNo>
<EmpNo>7876</EmpNo>
XMLELEMENT("EMPNO",EMPNO)
<EmpNo>7900</EmpNo>
<EmpNo>7902</EmpNo>
<EmpNo>7934</EmpNo>
14 rows selected.
PS.: Are "just" volunteers working here?YES.
Also , you might want to check out the XML DB Forum.
XML DB
Rahul.

Go to See the other 8 answers

OCI-21560 when using XMLElement

Category:DefaultRelease time:-0001-11-30Views:130

Dear All, I've just made my first step regarding to the XML field, but the following select caused me an error: select XMLElement ("colors", color) from my_colors; OCI-21560: argument 3 is null, invalid, or out of range I was looking for answers[More]

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

Category:DefaultRelease time:-0001-11-30Views:130

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 belo[More]

OO4O, OCI-21560 when selecting records with XMLTYPE column

Category:DefaultRelease time:-0001-11-30Views:130

When I try to select records from a table with XMLTYPE column Set sqldynaset = oraDatabase.dbcreatedynaset("select * from tab1", ORADYN_READONLY) I got the error message: OCI-21560: argument 3 is null, invalid, or out of range. Please help. Deve[More]

C/C++ OCI XML support examples

Category:DefaultRelease time:-0001-11-30Views:130

Hi all, I'm trying to find some simple C/C++ examples of accessing XMLType columns from OCI. I'm interested in examples that show the basics like querying an XMLType column and inserting values into an XMLType column. I'm mainly interested in example[More]

How to generate the following XML-Output?

Category:DefaultRelease time:-0001-11-30Views:130

Hi all, I would like to generate the following XML-Output without defining any types or tables: <?xml version = '1.0'?> <DEPARTMENTS_EMPLOYEES> <DEPARTMENT NAME="ACCOUNTING"> <DEPTNO>10</DEPTNO> <LOC>NEW YORK&[More]

XML Table

Category:DefaultRelease time:-0001-11-30Views:130

Hi Friends, This is XML Table: CREATE TABLE personal_data ( person_id NUMBER(13), person_data XMLTYPE); Insert Data into XML Table: insert into personal_data (person_id,person_data) values (1017,XMLTYPE(' <start>                <name>Sankarana[More]

OCICollAppend(.)  fails &  OCICollSize(.) fails  : OCI Error : 21500, 21560

Category:DefaultRelease time:-0001-11-30Views:130

Hi, My aggregate member function output/OUT parameter is a nested table or collection : table_out1 : table_out1 TABLE OF NTAB_TYPE Name Null? Type EMPNO NUMBER SALARY NUMBER TST CHAR(10) TE CHAR(10) And this table_out1 is not part/column of any datab[More]

XMLElement() returns 'XMLTYPE()'

Category:DefaultRelease time:-0001-11-30Views:130

Hi. I'm a newbie to Oracle XML, and I'm having trouble just getting off the ground. I would expect the following SQL statement: select xmlelement("dummy",dummy) result from dual; to return RESULT <dummy>X</dummy> but instead it retur[More]

Error while creating a report that uses Oracle OCI JDBC connectivity

Category:DefaultRelease time:2015-10-11Views:130

Please let me know why my CR and LF characters are removed from my forum posting ***** Hi, I was trying to create a report that uses Oracle OCI JDBC connectivity. I am using Eclipse3.4 download from "cr4e-all-in-one-win_2.0.2.zip".  I have succe[More]

Error when running a oci program

Category:DefaultRelease time:2015-10-11Views:130

I have a oci program copiled on solaris.when i try to run it in another machine it stops giving a strange message:: I get the following error message. fatal: relocation error: file sqlplus: symbol naemd5s: reference symbol not found : killed nulli'm[More]

Which OCI library to use for static linking with application on Unix, Linux

Category:DefaultRelease time:2015-10-11Views:130

Hi Friends I am new to OCI programming. I am developing a C++ application that works on Windows 7 (32, 64 bit, VS-9) and Linux (32, 64 bit), with OCI-11.2.0.3 version and Oracle 10g Express edition. I want to statically link OCI library in my applica[More]

Hot
11-inch, Mid 2013 MacBook Air. Upgraded to OS X Mavericks in December 2013 - have downloaded every fix/patch as prompted by the App Store. Relatively simple use pattern - word processing and web work. No bootcamp or 3rd party software, out side of Mo [More]
Hi! I need some assistance with LV-RT.  What I have succeeded is to enalble the web server on NI 17XX camera and successfully displayed a VI with Image Display on it. I thikn I got the hang of it.  What I would like to know is there another way to di [More]
Hi All, I  send email notifications on insatnce failure of Scheduled reports by configuring notification option in CMC. I would like to send the Error message for insatnce failure in the message content. Is there any way to achieve this ?Any dynamic [More]
Hi all, In PI 7.1 receiver SOAP adapter using https, what are the configurations necessary in PI box? Certification, and key store values, security etc etc -Michael.> Michael Johnson wrote: > I did n't find anything related to 7.1 version Some leads [More]
I just purchased adobe photoshop elements 11 and edited my first photo and now i am finished with it.  How do i get that photo to re save as a new JPEG file?  If i go to mmyu media organizer it says that it is currnetly being edited, but im done and [More]
Hi , I'm running the following simple query in sql*plus on ORACLE9i. But this query stopped running after 30minutes, and the sql*plus die at the same time .I have no idea about this. Could somebody tell me how I can solve this problem. Thank you very [More]
Hey Folks I am trying to create a billing document, which is an Export Billing Document. I have maintained my Customer address in Australia. When i save my billing document, i get a message " foreign trade data incomplete" in which case i cannot [More]
Hi,    I have a requirment at the client that we need to scrap an expensed GR item. When I tried 551, it is asking for a storage location. But this item is not stored in any storage location.  It is expensed to a cost center during GR. Can anyone let [More]
Greetings: I have been working on a fairly large project in FCE for many months. I am finally ready to export to burn onto a DVD but am having some strange problems. Although everything looks fine within FCE, when exported to a Quicktime movie as eit [More]
For weeks, I have been experiencing an ongoing issue with my MacBook pro. I got my battery replaced, and then afterwards... I began getting all these unwanted pop ups, as well as ads regarding cleaning my MacBook.  Additionally, I cannot open ANY att [More]