I'm not sure what I'm doing wrong here, but I am not able to get value
based on the following query:

select TYPE_ID from MY_TABLE where MY_TABLE.COLUMN_1 = 123456

This query works when I run it in my SQL developer tool displaying the
value I would expect to see. But when running this query from within
Perl it returns a '1' value.

Perl?? Hmm, boy are you in the wrong place, However.....
you may want to try somthing like this

select TYPE_ID from MY_TABLE where COLUMN_1 = 123456

You never know, maybe 1 is the correct response.


Dominic

<pzimmermann [at] gmail.com> wrote in message
news:7d68aa55-18bf-444c-9f26-c1bdd927ff44 [at] m34g2000hsb.google groups.com...
> I'm not sure what I'm doing wrong here, but I am not able to get value
> based on the following query:
>
> select TYPE_ID from MY_TABLE where MY_TABLE.COLUMN_1 = 123456
>
> This query works when I run it in my SQL developer tool displaying the
> value I would expect to see. But when running this query from within
> Perl it returns a '1' value.