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 (DOT) com> wrote