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
When I try to use my Computer section on my Apple TV so that I can view movies or music in my iTunes library it gives me the error "Turn on Home Sharing in iTunes".  Of course I have done that already in iTunes on my computer.  I went into my iT [More]
Need help in mappning my data model into java classes; Here are some of the details: Table, Poll: PollID int PollName varchar BusinessUnit varchar DisplaySchemeID int // reference to DisplayScheme table. Table, DisplayScheme DisplaySchemeID DisplaySc [More]
Hi Guruu2019s, Has anyone compared the features/functionalities of SAP BPC Consolidation with SEM? What are the advantages of BPC Consolidation over SEM, and vice-versa? Regards, SivarajHi Sivaraj, Though we don't have any document addressing this, i [More]
Hello All, I'm looking for overview and some information on FI planning , can some body help me out on this. Thanks Venkat Moderator: Please, read and respect SDN rulesIf you are with version 4.70 please use transaction code FSE5N - Enter data  for G [More]
Hi, We are trying to link GLPCA to BSEG via the Reference Doc No in GLPCA.  This is to get the reference field in BSEG.  All seems to work well for finance documents, but when we work with GLPCA Sales Doc Types RV the REFDOC Line has the line of the [More]
I am trying to migrate database from Sybase 12.0 to Oracle 9i using OMWB. I just created a test table and tried out the migration but I get an error in the first step of capturing model itself. Here is the error that I am getting while migration "Fai [More]
Application is for report generation based on the huge amount of data present in the database. JDBC query results me in out of memory error while fetching 72000 records. Any solution from the application side that could resolve this problem. Mail [em [More]
Hi Experts, I am designing a scenario where my source is a flat file and the target SAP. According to the content of the file, we would like to group the data per company and then send the grouped data. The question is, is it possible to send data in [More]
I just bought a new iMac and Adobe CS3 web premium software yesterday. I installed on the new iMac, then installed the software on my 1.5 year old MacBook Pro. On the laptop everything seems to be working fine, except the Flash player won't work when [More]
I want to expand the memory on a friends computer but I need to Know what is ment by "EDO" and what is different about this configuration of memory and if someone knows what does EDO stand for ?Extended Data Out - see definitions at: http://www. [More]