SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Error when using alter type statement

523861Oct 13 2009 — edited Oct 13 2009

Hi all:

Database Version: Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - 64bi

I have a type that is referenced in packages only (as far as I can tell) and I am trying to add columns to it.

SQL > alter type DEAL_CURRENCY add attribute (PRCNG_CCY_CD varchar2(3));
alter type DEAL_CURRENCY add attribute (PRCNG_CCY_CD varchar2(3))
*
ERROR at line 1:
ORA-22324: altered type has compilation errors
ORA-22328: object "APP"."DEAL_CURRENCY" has errors.
PLS-00103: Encountered the symbol "ADD" when expecting one of the following:
. modify

I have read the documentation here but have had no luck

Locked Post

New comments cannot be posted to this locked post.

Locked on Nov 10 2009

Added on Oct 13 2009

9 comments

699 views