Re: Migration Oracle 8.17 -> 9.2.0.4

Dennis Bieling wrote:

> Hi @all!
>
> I migrated an oracle databse from release 8.1.7 to
> 9.2.0.4 using the migration wizard. After the migration process
> I started the utlnchar.sql to update the NCHARS.
> Everything worked fine so far. But now I am realizing
> a problem with some nested tables, which might be a problem
> with not correctly converted NCHARS.
> All data is accessable via sqlplus without any problems, but
> connecting via JDBC gives just "???" as result
> out of queries on nested tables (data type varchar2).
> Querying the original database works fine.
> Has anyone a clue what might have gone wrong here?
>
> Best regards
> Dennis
>

I am trying to make my students aware of real-world uses for nested tables and would
appreciate any brief description of where your organization is using them and why the
choice was made to use nested tables rather than relational tables with object views.

Thanks.

-- 
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)