Graham wrote:
> GOT IT!.. It was the error message which was confusing me. What Oracle
> was trying to say was that I didn't have access (by the user of the
> connection) to one of the tables. Once I fixed this - it worked.

Great!  Error messages can be a nuisance sometimes.

> In answer to your 2nd part, the table() construct allow me to wrap the
> return values of the stored procedure call to an Oracle / LDAP
> interface as an anonymous table. Nice construct (no idea if any other
> database would support it though)

Ah!  Learn something new every day...  My guess would be that there is no
other database that supports this.  After all it's Oracle. :-)

> Thanks for trying to assist... just talking about it helps
> Graham

You're welcome!

Kind regards

    robert