My Oracle Support Banner

ORA-1780 From XMLTable XPath Query With CURSOR_SHARING=FORCE Or SIMILAR (Doc ID 1055339.1)

Last updated on AUGUST 03, 2014

Applies to:

Oracle Database - Enterprise Edition - Version 10.2.0.3 to 11.2.0.1 [Release 10.2 to 11.2]
Information in this document applies to any platform.
***Checked for relevance on 04-Aug-2014***

Symptoms

Running below SQL query raises error ORA-1780 when cursor_sharing is set to force or similar and works fine after changing CURSOR_SHARING parameter to exact in the query session.

SQL> alter session set cursor_sharing=force;

SQL> select qfa.ACTION_TYPE from
 apps_uk.GEDIS_QUOTE_FLIP_ACTIONS,
 xmltable ('$qfa/QuoteFlipAction' passing ACTION as "qfa" columns ACTION_TYPE varchar(20) path
'ActionType') qfa;
xmltable ('$qfa/QuoteFlipAction' passing ACTION as "qfa" columns ACTION_TYPE varchar(20) path 'Acti
*
ERROR at line 3:
ORA-01780: string literal required


Query works fine if cursor_sharing is set to exact;

SQL> alter session set cursor_sharing=exact;

Session altered.

SQL> select qfa.ACTION_TYPE from
 apps_uk.GEDIS_QUOTE_FLIP_ACTIONS,
 xmltable ('$qfa/QuoteFlipAction' passing ACTION as "qfa" columns ACTION_TYPE varchar(20) path
'ActionType') qfa
/

ACTION_TYPE
--------------------
Reject
Reject
Confirm
Reject
Reject
Reject

6 rows selected.

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution
References


This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.