Oracle.
I have type as following
create or replace
type string_varray as varray(200) of varchar2(1000);
I wants to increase size of varray from 200 to 1000 i tried following statement didn't work out for me
alter type string_varray MODIFY ( varray(1000) of varchar2(1000)) cascade;
Error
Error starting at line 4 in command:
alter type string_varray MODIFY (varray(1000) of varchar2(1000)) cascade
Error report:
SQL Error: ORA-22324: altered type has compilation errors
ORA-22328: object "DSC_APP"."STRING_VARRAY" has errors.
PLS-00103: Encountered the symbol "(" when expecting one of the following:
limit element
22324. 00000 - "altered type has compilation errors"
*Cause: The use of the ALTER TYPE statement caused a compilation error.
*Action: Correct the error reported and resubmit the statement.