XML Database (MOSC)

MOSC Banner

ORA-30951: Element or attribute at Xpath exceeds maximum length ORA-06512

edited Jun 23, 2013 8:00PM in XML Database (MOSC) 9 commentsAnswered
Hi , community, we're hitting a bug documented by oracle.

Is there any workaround to this bug

Current db version 11.2.0.2 , we're on the the latest PSU 9.

Query :

DECLARE
2 g_trans_type CHAR (20) := NULL;
3 BEGIN
4 SELECT x.transactionType
5 INTO g_trans_type
6 FROM test_gil t,
7 XMLTABLE (
8 '/ClaimRequest/Claim'
9 PASSING XMLPARSE (DOCUMENT t.c)
10 COLUMNS transactionType VARCHAR2 (20) PATH 'transactionType') x
11 WHERE t.a = '1 - insert_online_xml';
12 
13 DBMS_OUTPUT.put_line (g_trans_type);
14 END;
15 /
DECLARE
*
ERROR at line 1:
ORA-30951: Element or attribute at Xpath
exceeds maximum length
ORA-06512: at line 4

Regards,

Mzwandile

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center