Sitemap

Amicuk Programming Answers

OCI-21560 when using XMLElement

-0001-11-30   Views:4

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
Hi, Friends in my application file is to be sent with Email as an attachment. all this to be done via servlet for that i have to send the file to application server from there servlet will send mail via Email server. How can send this file to server. [More]
I Had used an hdmi adapter to comment my iPad2 to my TV with great ease. After upgrading to IOS 8 I plugged it in as ususal, the screen popped up on the TV for a moment then the TV went blank and I got an error on the pad that said this device was no [More]
I cancelled my BT Broadband Option 3 subscription around Nov 20th 2011 and I discovered on the internet that my BT Yahoo Premium mail would be terminated 90 days after my BT Broadband was cancelled, I've had my bt email account for around 10 years so [More]
what apps are available for 1st generation ipod touchHere's a list of Apps/games I've been able to download & play for 1st gen ipod touch: 1. Dragon Story 2. Dragon Village 3. World War 4. Rollercoaster Buggy 5. GTA: Chinatown Lite 6. iBrowser Free 7 [More]
No pdf documents are listed to open when I try to use the XI Pro, it only shows foldersnot sure what that means, I downloaded the program and when I try to open any file it only shows me foldersRead other 6 answers [More]
Hi , I am trying  to create a clause list and when I try Upload a clause list, at step 2 of Process request it is uploading till 80 percent and throwing an error " There is a problem with the contract generation web service. Contract your system admi [More]
In my project the requirement is how to read the hard dish serial number using java library. Please do let me now if u get any help or any information regarding this issue. This is urgent for meIn my project the requirement is how to read the hard di [More]
My Java application is invoking stored procedure(Oracle 10g). The stored procedure is opening a cursor for a SQL query that is created dynamically in side the procedure. Whenever there is an error while opening the cursor (i.e. executing the SQL quer [More]
Thanks!I know what you mean (image below). They go in the Lightroom folder, under pictures, in a randomly named folder. You can always drag them from this folder into your catalog, but I don't know of any way to reset the location or name of the fold [More]
Hi Experts, While   Posting Entry  useing T-code-F-02 i'm getting below error The entry T017 is missing in Table T052 and message No . F5100. What could be the reason? Kindly give valuable input. Shriram.Hi, Once in production whether that payment te [More]