complex datatypes and oracle 8

I wonder if any can help me?

Here's the problem

in 7 you can define a complex datatype WITHIN the function and return this type, however within 8 when you go to return use e.g.

create function .....
return ABC

'create ABC'

it returns an error saying ABC hasn't been defined, can someone PLEASE explain/help

please respond in group and via email

THANX Andrew Received on Mon Mar 22 1999 - 15:17:17 CST