Quoting Patch Error ORA-30556: Functional Index Defined On Column To Be Modified

(Doc ID 791245.1)

Last updated on OCTOBER 01, 2016

Applies to:

Oracle Order Capture - Version 11.5.10.2 to 11.5.10.2 [Release 11.5.10]
Information in this document applies to any platform.
***Checked for relevance on 3-Aug-2012***

Symptoms

Trying to apply an 11.5.10 Quoting patch and receive errors in Ad Worker log -
Start time for statement below is: Fri Dec 19 2008 05:34:06

ALTER TABLE ASO.ASO_QUOTE_HEADERS_ALL MODIFY ( QUOTE_NAME VARCHAR2(240) )

AD Worker error:
The following ORACLE error:

ORA-30556: functional index is defined on the column to be modified

 

 

SQL> describe ASO_QUOTE_HEADERS_ALL   

Shows the column size is 80 -

Name                                                             Null?     Type
----------------------------------------- --------  ----------------------------
QUOTE_NAME                                                           VARCHAR2(80)

Changes

Applying patches.

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