Passing VARCHAR2 Parameter Longer Then 4000 or 32768 Characters To SQL Function Inside A SQL Statement ends up with ORA-1460 or ORA-1461 (Doc ID 300268.1)

Last updated on APRIL 03, 2017

Applies to:

PL/SQL - Version 8.0.6.0 to 12.1.0.2 [Release 8.0.6 to 12.1]
Information in this document applies to any platform.
***Checked for relevance on 21-Nov-2014***


Symptoms

Executing a PLSQL block which runs a SQL Statement like SELECT that contains a SQL function like INSTR() and passed VARCHAR parameter to SQL Function is longer than 4000  characters following errors can occure depending on the performed statements

 

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms