Lookup data in Oracle database

[SQUASH JUNKIE]

Hi
I am trying to lookup data in an oracle table based on a value in my excel spreadsheet. I am using the DBVLOOKUP function that I found on Google, and am trying to convert the connection string to use an ORACLE connection.
The code I have is as follows...

Please Login or Register  to view this content.

The module does not show any errors, the SQL statement is correct, and it does seem to be connecting to the data. However I only get #value showing in my spreadsheet.
The function on the spreadsheet looks like..

Please Login or Register  to view this content.

where $F$23 is the cell that is being referenced for lookup in the Oracle DB.

I cant see what's going wrong , if someone could point me in the right direction that would be a great help.

Thx

[chergh]

I seem to recall that you can't do this with a UDF called from the worksheet. UDF's called from a worksheet are limited in what they can do see http://support.microsoft.com/kb/170787 for more details.

[SQUASH JUNKIE]

Thx for the reply chergh, but just so that I am clear on this, whats the difference between this function working with Access and not being able to work with Oracle?
There is no modification to the sheet, it's just a lookup function to return some values based on a user's entry in one cell.
Thx