| upd | what is packet name |
| dew | oookay i see, so i need to start with the topmost package, and look at @{$package . '::ISA'}, and walk down until i've got as far as I need to? |
| Caelum | dew: do you just want to check that something isa something else or do you need the whole tree? |
| dew | right, i need a list of all the methods available in whatever package $self is blessed into |
| f00li5h | dew: symboltable time! |
| dew | doing %{ref($self) . '::'} gives slight odd results |
| Caelum | not a trivial problem |
| LeoNerd | Define "slightly odd".. |
| dew | ie, it returns everything defined in the package, plus anything inherited that has actually been used |
| tolkor | hey all. i'm running into an issue that has me pulling my hair out. right after i inherited an oracle installation we had to do a crash move from oracle 8 to oracle 9(9.2.0.6 i believe). ithere is a perl script somebody wrote that is a frontend to DBI.pm that is used to modify records in an Oracle db. i wrote a small test script to ensure that i can connect to the db directly to make sure that part is working. however, when i feed the needed data to the perl front end, at the point of the DBI->connect I get a bark back: DBI connect('hostname=myhost;port=x, dsn=dbi:Oracle:mySID;username;...) failed: Constructor didn't return a handle: Welcome! at first i thought it was an oracle issue but now i'm not sure. i have used cpan to upgrade the perl modules. i've been web searching, doc pouring, and poking around in the dbi archives on cpan but cannot seem to find what may be g oing on. i've even tried stepping through everything via the debugger. as i understand the docs the proper strings are being sent in. i have also verified that oracle is indeed sending back the "Welcome!" which of course is not the construct needed for the DBI->connect. poking around in the modules, plclient.pm gets back a "ARRAY(0x452174)" which contains the "Welcome!" is this behavior documented someplace or does anybody have a pointer on how to solve the problem? |
| dew | whoa paste |
| action | tolkor rests the fingers. |
| tolkor | rests the fingers. nope. just mad-dash typing. hopfully not too many typos. |
| dew | :) |
| Caelum | tolkor: that's extremely odd |
| tolkor | yeah. it has me pulling out my few remaining hairs. ;> |
| Caelum | tolkor: what happens if you just do something like perl -MDBI -le 'DBI->connect("dbi:Oracle:SID","scott","tiger")' |
| tolkor | lemme go check. ok. did the 1-liner and got back nothing. i do have a short script that does something similar that reports success. the connect is: my $dbhandle = DBI->connect("dbi:Oracle:$dataSource", $userName, $password) |
| dew | that'll probably do nothing either way, check for errors? |
| tolkor | oops, forgot the second half: or die "Can't connect to the Oracle Database: $DBI::errstr\n"; |
| dew | that's better :) |
| tolkor | ;> |
| dew | so the oneliner does nothing with that error code on? if so then it's not erroring.. run a simple query and check it's working ..? |
| tolkor | <smack> lemme go try with the die. |
| dew | ;) |
| tolkor | yup. success. no die. |
| action | Caelum recommends using ssh to avoid having to run between computers :) |
| Caelum | recommends using ssh to avoid having to run between computers :) ok, so something is wrong with that particular program |
| dew | nice then you have something random happening tho i'd expand that oneliner to run a query and get a result, just to make sure |
| tolkor | caelum: naw, just too many windows on an old slow laptop right now. |