Re: DBA requires basic SQL assistance please (LONG POST)

Norman Dunbar <Norman.Dunbar_at_lfs.co.uk> wrote in news:E2F6A70FE45242488C865C3BC1245DA7036895A4_at_lnewton.leeds.lfs.co.uk:

> Martin,
>
> Thanks for that - I never used that sort of object casting before when I
> got it to work. However, I'll give it a try.
>
> Cheers,
> Norman.
>

Norman,

You are correct, I looked at the link rajXesh posted from Ask Tom, and the object part is not needed, I cut the code down from an example where I needed a ref cursor, to a single column, and in that case a simple table of varchar2 for the type will be fine. You'll still need the cast syntax on the subselect though.

Martin Received on Tue Mar 11 2003 - 20:15:22 CST