Hitting Oracle from an ASP page

[curious_Lee]

An error keeps popping up on my ASP application connecting to an Oracle 9i
database via a SELECT statement:

Item cannot be found in the collection
corresponding to the requested name or ordinal.

However, if I put it an "On Error Resume Next", it works fine, and is able
to return the value in question. The SELECT also works fine on the database
itself. Here's the SELECT,

sqlstr = "select f_get_dept_name('123') dept_name from myschema.tbl_xyz"

sqlstr = sqlstr & " where tbl_xzy_id = 4567"

What in the world is going on??

[Turkbear]

On Mon, 10 Oct 2005 11:12:43 -0400, "curious_Lee" <on***************@yahoo.com> wrote:

An error keeps popping up on my ASP application connecting to an Oracle 9i
database via a SELECT statement:

Item cannot be found in the collection
corresponding to the requested name or ordinal.

However, if I put it an "On Error Resume Next", it works fine, and is able
to return the value in question. The SELECT also works fine on the database
itself. Here's the SELECT,

sqlstr = "select f_get_dept_name('123') dept_name from myschema.tbl_xyz"

sqlstr = sqlstr & " where tbl_xzy_id = 4567"

What in the world is going on??

Can you post the line that causes the error..Also, have you run the Sql created by the code directly?

( Use a Response.Write(sqlstr) to see exactly what is being sent to the database).

[Brian Staff]

The fact that it appears to work when specifying "ON ERROR RESUME NEXT" suggest
that your "select" statement is working fine.

I suspect the error is being recorded later on in your code, when you try to
use a "column" in that recordset. I think you may be trying to accesss a column
that has not been retrieved in the SELECT statement...or you have a spelling
mistake...or the "case" of the column name may be wrong.

Brian

[curious_Lee]

Art,

Here's the other response.

"Turkbear" <no***@nowhere.com> wrote in message
news:vf********************************@4ax.com...

On Mon, 10 Oct 2005 11:12:43 -0400, "curious_Lee"
<on***************@yahoo.com> wrote:

An error keeps popping up on my ASP application connecting to an Oracle 9i
database via a SELECT statement:

Item cannot be found in the collection
corresponding to the requested name or ordinal.

However, if I put it an "On Error Resume Next", it works fine, and is able
to return the value in question. The SELECT also works fine on the
database
itself. Here's the SELECT,

sqlstr = "select f_get_dept_name('123') dept_name from myschema.tbl_xyz"

sqlstr = sqlstr & " where tbl_xzy_id = 4567"

What in the world is going on??

Can you post the line that causes the error..Also, have you run the Sql
created by the code directly?

( Use a Response.Write(sqlstr) to see exactly what is being sent to the
database).