DBA requires basic SQL assistance please (LONG POST)

From: Norman Dunbar <Norman.Dunbar_at_lfs.co.uk>
Date: Wed, 12 Mar 2003 09:22:47 -0000
Message-ID: <E2F6A70FE45242488C865C3BC1245DA70369E009@lnewton.leeds.lfs.co.uk>

Hi Martin,

I followd the link and used your example as well. I have a better understanding of what is needed and I've even (almost) got it to work. I can select the employee_ids from my soundex table ok but when I wrap that in a select to get the actual employee names from the employee table, it 7445's on me with exception 11. I've raised a TAR with Oracle support.

Cheers,
Norman.

Norman Dunbar
Database/Unix administrator
Lynx Financial Systems Ltd.
mailto:Norman.Dunbar_at_LFS.co.uk

Tel: 0113 289 6265
Fax: 0113 289 3146
URL: http://www.Lynx-FS.com


-------------------------------------

-----Original Message-----
From: Martin Burbridge [mailto:pobox002_at_bebub.com] Posted At: Wednesday, March 12, 2003 2:15 AM Posted To: server
Conversation: DBA requires basic SQL assistance please (LONG POST) Subject: Re: DBA requires basic SQL assistance please (LONG POST)

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 Wed Mar 12 2003 - 03:22:47 CST