Sitemap

Amicuk Programming Answers

OCI-21560 when using XMLElement

-0001-11-30   Views:5

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
I cannot keep the Safari toolbar showing.  The "Hide Toolbar" in the View tab is grayed out.  Also, I cannot get the dock to not hide.Press the escape (esc) key to exit full-screen mode.Read other 3 answers [More]
I left my iPod (iPod Classic, 80GB, purchased May 08, I believe it's the current generation) to charge overnight and this morning I wanted to sync it up to get some podcasts that had downloaded overnight. After I did the sync, I ejected the iPod and [More]
Hi I just connected to iTunes so I could add some new songs to my iPod - it wiped my collection from the iPod.  I did a reset, then a restore and finally a factory reset.  The factory reset seemed to work, as my iTunes advised it was syncing (about a [More]
Is it normal in Mail for the beach ball to spin simply while it is loading new messages? If so, I have a new app to dump. I hope it is just a setting I need to adjust. ThanksTry rebuilding the mailbox. This can take awhile if you have a lot of mail. [More]
Hi, Please help me with the below code: It is updating null if the select statment returns one values. If it fetches multiple values then it throughs the below error msg when running the program. Please let me know how to modify the below code. Or le [More]
I am having problems playing half my games on facebook because of abod flash player is there any way around this?Not for interactive content such as games. (60255)Read other 2 answers [More]
Hi, can we know what excatly job purpose is like for what purpse it is created or in other words what is the basic idea behind creating job, who has created the job , when he has cretaed the job etc if u know the job name? Thanks, RaviHi... 1.Go to S [More]
My Pages 09 document has circles with a diagonal line through it (like a Do Not symbol) scattered across 14 pages. They appear to be dimmed and I can't select or click on them.  I think they might be related to previous figures or text boxes that I h [More]
Hi , I use SQL Developer for querying Database . The problem is that after getting data as a result of a Search operation inside Oracle SQL Developer tool , i can't able to export those Data using export Option of Oracle SQL Developer . Could anybody [More]
Hi, When creating the PR in ME51N after entering the item data and service limit details am facing an error message like "order type is not matching with account assignment category". Here my problem is whenever i click on BACK,EXIT AND CANCEL O [More]