P
Peter.Kramer
hi there
I'm wondering why I cant get all resulst in my hasref in this statement:
--
select r.resourcesize, a.samaccountname
from aduser a
(
select * from resourcesize
where ts = (select max(ts) from resourcesize where server = 'xyz')
) r
where a.samaccountname = r.samaccountname(+)
----
What I get is an hasref and all data from table "a" and all fields of table
"r" but no data of table "r".
I assume, that the sub select is the problem.
result:
$hash->{SAMACCOUNTNAME} = "tiger"
$hash->{RESOURCESIZE} = ""
When I execute the script in SQL Plus all Data is availible!
$hash->{SAMACCOUNTNAME} = "tiger"
$hash->{RESOURCESIZE} = "1234"
I'm using Active State Perl 5.8.4 with DBD-Oracle and Oracle 9i
I'm wondering why I cant get all resulst in my hasref in this statement:
--
select r.resourcesize, a.samaccountname
from aduser a
(
select * from resourcesize
where ts = (select max(ts) from resourcesize where server = 'xyz')
) r
where a.samaccountname = r.samaccountname(+)
----
What I get is an hasref and all data from table "a" and all fields of table
"r" but no data of table "r".
I assume, that the sub select is the problem.
result:
$hash->{SAMACCOUNTNAME} = "tiger"
$hash->{RESOURCESIZE} = ""
When I execute the script in SQL Plus all Data is availible!
$hash->{SAMACCOUNTNAME} = "tiger"
$hash->{RESOURCESIZE} = "1234"
I'm using Active State Perl 5.8.4 with DBD-Oracle and Oracle 9i