[Catalyst] Catalyst Application : DBIx::Class : Oracle 8 : JOIN problem

[Jorge Gonzalez]

SGkgUm9oYW4sCgpzZWVtcyB0aGF0IEkgd2FzIHByZXR0eSB3cm9uZyByZWdhcmRpbmcgT3JhY2xl
IEFOU0kgSk9JTiBzeW50YXgsIApldmVyeW9uZSBwbGVhc2UgYWNjZXB0IG15IGFwb2xvZ2llcy4g
SSdsbCBkb3VibGUgY2hlY2sgYmVmb3JlIHBvc3RpbmcgCm5leHQgdGltZS4gRXZlbiB0aGluZ3Mg
dGhhdCBzZWVtIGltcHJvYmFibGUuIDotKQoKU29ycnkgYWdhaW4uIFRoaXMgdGltZSBJIGFsc28g
bGVhcm50IHNvbWV0aGluZy4KUmVnYXJkcwpKLgoKCkVsIDMwLzA1LzExIDExOjU0LCBSb2hhbiBN
IGVzY3JpYmnDszoKPiBIZXkgSm9yZ2UsCj4KPiAgIFllcy4gVGhlIGpvaW4gcGFyYW1ldGVyIGlz
IHRoZSBuYW1lIG9mIERCSXg6OkNsYXNzIHJlbGF0aW9uIHRvIHRoZSAKPiBmb3JlaWduIHRhYmxl
IGFuZCBJJ20gdXNpbmcgdGhlIHJlbGF0aW9uIG5hbWUgbm90IHRoZSBmb3JlaWduIGtleSAKPiBu
YW1lLiBTbyB0aGF0J3Mgbm90IGEgcHJvYmxlbS4KPgo+IFllcyBJJ20gdXNpbmcgREJJQ19UUkFD
RSBhbmQgSSBzZWUgZm9sbG93aW5nIG91dHB1dCBpbiBteSBDYXRhbHlzdCBhcHAgCj4gY29uc29s
ZS4KPgo+IERCSSBFeGNlcHRpb246IERCRDo6T3JhY2xlOjpkYiBwcmVwYXJlX2NhY2hlZCBmYWls
ZWQ6IE9SQS0wMDkzMzogU1FMIAo+IGNvbW1hbmQgbm90IHByb3Blcmx5IGVuZGVkIChEQkQgRVJS
T1I6IGVycm9yIHBvc3NpYmx5IG5lYXIgPCo+IAo+IGluZGljYXRvciBhdCBjaGFyIC4uLi4KPgo+
IFNFTEVDVCBtZS5sb2dpZCwgbWUuc3RhdHVzLCBtZS50aW1lZGV0YWlscywgZW1wbG95ZWUuaWQg
Cj4gPGh0dHA6Ly9lbXBsb3llZS5pZD4sIGVtcGxveWVlLm5hbWUgPGh0dHA6Ly9lbXBsb3llZS5u
YW1lPiwgCj4gZW1wbG95ZWUucGhvbmUsIGVtcGxveWVlLmVtYWlsIEZST00gUEd4X0xPRyBtZSA8
Kj5KT0lOIGVtcGxveWVlIAo+IGVtcGxveWVlIE9OIGVtcGxveWVlLnVzZXJpZCA9IG1lLmlkIDxo
dHRwOi8vbWUuaWQ+IFdIRVJFICggc29tZW90aGVyaWQgCj4gPSA/ICkKPgo+IElmIEkgdHJ5IHRv
IHVzZSB0aGUgc2FtZSBxdWVyeSBkaXJlY3RseSBvbiBzcWwgcHJvbXB0IHRoZXJlIGFsc28gSSBn
ZXQgCj4gdGhlIHNhbWUgZXJyb3IuCj4KPiBJIGNoZWNrZWQgZm9yIHRoZSBPcmFjbGUgOGkgc3Fs
IHN0YXRlbWVudHMgLQo+Cj4gaHR0cDovL29yZWlsbHkuY29tL2NhdGFsb2cvb3JzcWxwbHVzcHIy
L2NoYXB0ZXIvY2gwMS5odG1sCj4KPiBodHRwOi8vd3d3LmRiYS1vcmFjbGUuY29tL2FydF9zcWxf
aXNvXzk5Lmh0bQo+Cj4gVGhpcyB0ZWxscyB5b3UgdGhhdCBPcmFjbGUgOGkgZG9lcyBub3Qgc3Vw
cG9ydCBzdWNoIHN5bnRheC4KPj4gImh0dHA6Ly9zZWFyY2guY3Bhbi5vcmcvfmZyZXcvREJJeC1D
bGFzcy0wLjA4MTE1L2xpYi9EQkl4L0NsYXNzL1N0b3JhZ2UvREJJL09yYWNsZS9XaGVyZUpvaW5z
LnBtIAo+PiA8aHR0cDovL3NlYXJjaC5jcGFuLm9yZy8lN0VmcmV3L0RCSXgtQ2xhc3MtMC4wODEx
NS9saWIvREJJeC9DbGFzcy9TdG9yYWdlL0RCSS9PcmFjbGUvV2hlcmVKb2lucy5wbT4iIAo+Pgo+
IEFsc28sIHRoZSBhYm92ZSBsaW5rIHRlbGxzIHRoYXQgdGhlIGpvaW5zIGFyZSBkaWZmZXJlbnRs
eSBoYW5kbGVkIGJ5IAo+IGZvciBPcmFjbGUgOGkuCj4KPiBQbGVhc2UgbGV0IG1lIGtub3cgaWYg
SSdtIGRvaW5nIHNvbWV0aGluZyB3cm9uZy4KPgo+IFJlZ2FyZHMsCj4gUm9oYW4KPgo+Cj4gT24g
TW9uLCBNYXkgMzAsIDIwMTEgYXQgMTowMCBQTSwgSm9yZ2UgR29uemFsZXogCj4gPGpvcmdlLmdv
bnphbGV6QGRhaWtvbi5lcyA8bWFpbHRvOmpvcmdlLmdvbnphbGV6QGRhaWtvbi5lcz4+IHdyb3Rl
Ogo+Cj4gICAgIFRoZSBhcmd1bWVudCB0byAnam9pbicgcGFyYW1ldGVyIG11c3QgYmUgdGhlIG5h
bWUgb2YgdGhlCj4gICAgIERCSXg6OkNsYXNzIHJlbGF0aW9uIHRvIHRoZSBmb3JlaWduIHRhYmxl
LCBub3QgdGhlIGZvcmVpZ24ga2V5Cj4gICAgIG5hbWUuIEluIHNvbWUgY2FzZXMgKGF1dG9nZW5l
cmF0ZWQgc2NoZW1hIHdpdGgKPiAgICAgREJpeDo6Q2xhc3M6OlNjaGVtYTo6TG9hZGVyKSB0aGV5
IHdpbGwgYmUgdGhlIHNhbWUsIGJ1dCBpbiBvdGhlcgo+ICAgICBjYXNlcyAoaS5lLiB3aGVuIHlv
dSBidWlsZCB0aGUgc2NoZW1hIGJ5IGhhbmQpLCB0aGlzIG1pZ2h0IG5vdAo+ICAgICBuZWNlc3Nh
cmlseSBiZSB0aGUgY2FzZS4KPgo+ICAgICBIYXZlIHlvdSBjaGVja2VkIHRoaXM/Cj4KPiAgICAg
SGF2ZSB5b3UgZXhlY3V0ZWQgeW91ciBzY3JpcHQgd2l0aCBEQklDX1RSQUNFPTEgdG8gc2VlIHRo
ZSBleGFjdAo+ICAgICBTUUwgd2hpY2ggaXMgYmVpbmcgZ2VuZXJhdGVkPwo+Cj4gICAgIENhbiB5
b3UgcG9zdCB0aGUgZXhhY3QgZXJyb3IgbWVzc2FnZSB0aGF0IE9yYWNsZSBnaXZlcyB5b3U/IEl0
J3MKPiAgICAgcXVpdGUgY2xlYXIgdGhhdCBPcmFjbGUgX2RvZXNfIHVuZGVyc3RhbmQgdGhlIEpP
SU4gc3ludGF4Cj4gICAgIHNpbmNlLi4uLi4gd2VsbCwgZm9yZXZlci4KPgo+ICAgICBDaGVlcnMK
PiAgICAgSi4KPgo+Cj4gICAgIAkqL0pvcmdlIEdvbnrDoWxleiBWaWxsYWxvbmdhLyoKPiAgICAg
RGlyZWN0b3IgVMOpY25pY28KPgo+ICAgICAqL0RBSUtPTiBJbnRlZ3JhY2nDs24geSBEZXNhcnJv
bGxvIFMuTC4vKgo+ICAgICBUZWxmOiAoKzM0KSA5MSAxODggMDggMjgKPiAgICAgRmF4OiAoKzM0
KSA5MSA2MzIgNjUgNDIKPiAgICAgKnd3dy5kYWlrb24uZXMgPGh0dHA6Ly93d3cuZGFpa29uLmVz
PioKPgo+Cj4gICAgIEVsIDI5LzA1LzExIDE5OjQ1LCBSb2hhbiBNIGVzY3JpYmnDszoKPj4gICAg
IERlYXIgQWxsLAo+Pgo+PiAgICAgIEknbSB1c2luZyBPcmFjbGUgOGkgYXMgYSBiYWNrLWVuZCBk
YXRhYmFzZSBzZXJ2ZXIgZm9yIG15Cj4+ICAgICBDYXRhbHlzdCBhcHBsaWNhdGlvbi4gV2hlbiBJ
IHRyeSB0byB1c2Ugam9pbiBwYXJhbWV0ZXIgdXNpbmcKPj4gICAgIERCSXg6OkNsYXNzIG1vZGVs
LCBpdCBnaXZlcyBtZSBzeW50YXggZXJyb3IuCj4+ICAgICBJdCBkb2Vzbid0IHVuZGVyc3RhbmQg
J0pPSU4nIGtleXdvcmQgaW4gdGhlIFNRTCBnZW5lcmF0ZWQgYnkKPj4gICAgIERCSXg6OkNsYXNz
Lgo+Pgo+PiAgICAgZm9yIGV4YW1wbGUgLSA+Cj4+Cj4+ICAgICBteSAkSW5mbyA9ICRjLT5tb2Rl
bCgnQXBwOjpMb2cnKS0+c2VhcmNoKHsKPj4gICAgIGlkID0+ICRzb21laWQsCj4+ICAgICB9LHsK
Pj4gICAgIGpvaW4gPT4gJ2ZvcmVpZ25rZXlfaWQnLAo+PiAgICAgfSk7Cj4+Cj4+ICAgICBJIGRp
ZCBjaGVja2VkCj4+ICAgICAiaHR0cDovL3NlYXJjaC5jcGFuLm9yZy9+ZnJldy9EQkl4LUNsYXNz
LTAuMDgxMTUvbGliL0RCSXgvQ2xhc3MvU3RvcmFnZS9EQkkvT3JhY2xlL1doZXJlSm9pbnMucG0K
Pj4gICAgIDxodHRwOi8vc2VhcmNoLmNwYW4ub3JnLyU3RWZyZXcvREJJeC1DbGFzcy0wLjA4MTE1
L2xpYi9EQkl4L0NsYXNzL1N0b3JhZ2UvREJJL09yYWNsZS9XaGVyZUpvaW5zLnBtPiIKPj4gICAg
ICB3aGVyZSBpdCBpcyBtZW50aW9uZWQgdGhhdCBEQkl4OjpDbGFzcyBhdXRvbWF0aWNhbGx5IGRl
dGVjdHMgdGhlCj4+ICAgICB2ZXJzaW9uIGFuZCBjYWxscyB0aGUgYWJvdmUgY2xhc3MgdG8gZ2Vu
ZXJhdGUgdGhlIEpPSU4gaW4gb3JhY2xlCj4+ICAgICA4aSBmYXNoaW9uIGJ1dCBzb21laG93IGl0
cyBub3Qgd29ya2luZy4KPj4KPj4gICAgIEFsc28gSSBjaGVja2VkIGZvciBqb2luX3R5cGUgcGFy
YW1ldGVyIHdoaWNoIGFsbG93cyB5b3UgdG8gZ28gZm9yCj4+ICAgICAnb3V0ZXInIG9yICdpbm5l
cicgam9pbiBidXQgaXQgZGlkbid0IHdvcmsuCj4+Cj4+ICAgICBDb3VsZCBzb21lIGJvZHkgdGVs
bCBtZSBob3cgY2FuIEkgdXNlIGpvaW4gZm9yIG9yYWNsZSA4aSB1c2luZwo+PiAgICAgREJJeDo6
Q2xhc3MgbW9kZWwgaW4gdGhlIENhdGFseXN0IGFwcGxpY2F0aW9uPwo+Pgo+Pgo+PiAgICAgVGhh
bmtzIGFuZCByZWdhcmRzLAo+PiAgICAgUm9oYW4KPj4KPj4KPj4KPj4KPj4KPj4gICAgIF9fX19f
X19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fCj4+ICAgICBMaXN0OkNh
dGFseXN0QGxpc3RzLnNjc3lzLmNvLnVrICA8bWFpbHRvOkNhdGFseXN0QGxpc3RzLnNjc3lzLmNv
LnVrPgo+PiAgICAgTGlzdGluZm86aHR0cDovL2xpc3RzLnNjc3lzLmNvLnVrL2NnaS1iaW4vbWFp
bG1hbi9saXN0aW5mby9jYXRhbHlzdAo+PiAgICAgU2VhcmNoYWJsZSBhcmNoaXZlOmh0dHA6Ly93
d3cubWFpbC1hcmNoaXZlLmNvbS9jYXRhbHlzdEBsaXN0cy5zY3N5cy5jby51ay8KPj4gICAgIERl
diBzaXRlOmh0dHA6Ly9kZXYuY2F0YWx5c3QucGVybC5vcmcvCj4+ICAgICAgICAKPgo+ICAgICBf
X19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fXwo+ICAgICBMaXN0
OiBDYXRhbHlzdEBsaXN0cy5zY3N5cy5jby51ayA8bWFpbHRvOkNhdGFseXN0QGxpc3RzLnNjc3lz
LmNvLnVrPgo+ICAgICBMaXN0aW5mbzogaHR0cDovL2xpc3RzLnNjc3lzLmNvLnVrL2NnaS1iaW4v
bWFpbG1hbi9saXN0aW5mby9jYXRhbHlzdAo+ICAgICBTZWFyY2hhYmxlIGFyY2hpdmU6Cj4gICAg
IGh0dHA6Ly93d3cubWFpbC1hcmNoaXZlLmNvbS9jYXRhbHlzdEBsaXN0cy5zY3N5cy5jby51ay8K
PiAgICAgRGV2IHNpdGU6IGh0dHA6Ly9kZXYuY2F0YWx5c3QucGVybC5vcmcvCj4KPgo+Cj4KPgo+
IF9fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fCj4gTGlzdDog
Q2F0YWx5c3RAbGlzdHMuc2NzeXMuY28udWsKPiBMaXN0aW5mbzogaHR0cDovL2xpc3RzLnNjc3lz
LmNvLnVrL2NnaS1iaW4vbWFpbG1hbi9saXN0aW5mby9jYXRhbHlzdAo+IFNlYXJjaGFibGUgYXJj
aGl2ZTogaHR0cDovL3d3dy5tYWlsLWFyY2hpdmUuY29tL2NhdGFseXN0QGxpc3RzLnNjc3lzLmNv
LnVrLwo+IERldiBzaXRlOiBodHRwOi8vZGV2LmNhdGFseXN0LnBlcmwub3JnLwo+ICAgIAotLS0t
LS0tLS0tLS0tLSBuZXh0IHBhcnQgLS0tLS0tLS0tLS0tLS0KU2tpcHBlZCBjb250ZW50IG9mIHR5
cGUgbXVsdGlwYXJ0L3JlbGF0ZWQ=