Re: Insert data into varray

VARRAYs are "arrays" not "tables", as their name implies. INSERT statements work on tables, not on arrays.

Neither VARRAYs nor nested tables are useful datatypes for creating tables IMHO - what's wrong with creating a separate table for the phone numbers?

Marcin 'dethar' Jurasz wrote:
> UPDATE tab_customers SET phone_nos = t_vphonenos('1212','12123')
> WHERE id = 5;
>
> it works, but i'd like to do it by insert:
>
> before insert | after insert
> ----------------------------
> t_vphonenos | t_vphonenos
> ----------------------------
> '1212' | '1212', '13143'
>
> NESTED TABLE is (i think) not the same as VARRAY, because i already
> did an insert into NESTED. Into VARRAY - by now - i can only update.
>
> An example from psoug.org after I've modified, it seems I've doing ok
> with my clause. But it still doesn't work. Oracle 8i. It could be a
> problem?
> --
> regards
Received on Fri Apr 29 2005 - 04:19:53 CDT