I decided that it would be the right time to update my DBD::Oracle 1.28
to the latest and the greatest version, which is 1.34. I ran "make test",
an old habit which stuck with me since I've encountered some not so well
tested modules, and everything was peachy. The module got properly
installed but the recycle bin was full of junk:

SQL> select owner,object_name,original_name,can_undrop,can_pur ge
2 from dba_recyclebin;

OWNER OBJECT_NAME ORIGINAL_NAME CAN CAN
----- -------------------- -------------------------------- --- ---
SCOTT BIN$sNwS4xrmQ+rgQ2QB SYS_C0038375 NO YES
qMBihQ==$0

SCOTT BIN$sNwS4xrnQ+rgQ2QB DBD_ORA__DROP_ME YES YES
qMBihQ==$0

SCOTT BIN$sNwS4xrpQ+rgQ2QB SYS_C0038376 NO YES
qMBihQ==$0

SCOTT BIN$sNwS4xrqQ+rgQ2QB DBD_ORA__DROP_ME YES YES
qMBihQ==$0

SCOTT BIN$sNwS4xrsQ+rgQ2QB SYS_C0038377 NO YES
qMBihQ==$0

SCOTT BIN$sNwS4xrtQ+rgQ2QB DBD_ORA__DROP_ME YES YES
qMBihQ==$0

SCOTT BIN$sNwS4xrvQ+rgQ2QB SYS_C0038378 NO YES
qMBihQ==$0

SCOTT BIN$sNwS4xrwQ+rgQ2QB DBD_ORA__DROP_ME YES YES
qMBihQ==$0

SCOTT BIN$sNwTFEcqQ+7gQ2QB DBD_ORA__DROP_ME YES YES
qMDJYg==$0

SCOTT BIN$sNwTG+2YQ/DgQ2QB DBD_ORA__DROP_ME YES YES
qMB2mw==$0

SCOTT BIN$sNwTJoRpQ/LgQ2QB DBD_ORA__DROP_ME YES YES
qMDCcA==$0

SCOTT BIN$sNwTLAXVQ/TgQ2QB DBD_ORA__DROP_ME YES YES
qMBMnw==$0

SCOTT BIN$sNwTMt7FQ/bgQ2QB DBD_ORA__DROP_ME YES YES
qMDadA==$0

SCOTT BIN$sNwTOL0pQ/jgQ2QB DBD_ORA__DROP_ME YES YES
qMA76A==$0

SCOTT BIN$sNwTQaEKQ/7gQ2QB DBD_ORA__DROP_ME YES YES
qMBltg==$0

SCOTT BIN$sNwTQaELQ/7gQ2QB DBD_ORA__DROP_ME YES YES
qMBltg==$0

SCOTT BIN$sNwTjSilRALgQ2QB SYS_C0038379 NO YES
qMAecg==$0

SCOTT BIN$sNwTjSimRALgQ2QB PERL_DBD_EXECUTE_ARRAY YES YES
qMAecg==$0

SCOTT BIN$sNwTjSioRALgQ2QB SYS_C0038380 NO YES
qMAecg==$0

SCOTT BIN$sNwTjSipRALgQ2QB PERL_DBD_EXECUTE_ARRAY2 YES YES
qMAecg==$0

SCOTT BIN$sNwTmZRgRATgQ2QB TRG_ARRAY_IN_OUT_TESTST NO NO
qMDH0g==$0

SCOTT BIN$sNwTmZRhRATgQ2QB ARRAY_IN_OUT_TEST YES YES
qMDH0g==$0

SCOTT BIN$sNwTpVRaRAbgQ2QB DBD_ORA__DROP_ME YES YES
qMAHiw==$0

SCOTT BIN$sNwTpVRbRAbgQ2QB DBD_ORA__DROP_ME YES YES
qMAHiw==$0

SCOTT SYS_IL0000107205C000 SYS_IL0000107205C00002$$ NO NO
02$$

SCOTT SYS_LOB0000107205C00 SYS_LOB0000107205C00002$$ NO NO
002$$

SCOTT BIN$sNwTpVRcRAbgQ2QB DBD_ORA__DROP_ME YES YES
qMAHiw==$0

SCOTT SYS_IL0000107208C000 SYS_IL0000107208C00002$$ NO NO
02$$

SCOTT SYS_LOB0000107208C00 SYS_LOB0000107208C00002$$ NO NO
002$$

SCOTT BIN$sNwTpVRdRAbgQ2QB DBD_ORA__DROP_ME YES YES
qMAHiw==$0

SCOTT SYS_IL0000107211C000 SYS_IL0000107211C00002$$ NO NO
02$$

SCOTT SYS_LOB0000107211C00 SYS_LOB0000107211C00002$$ NO NO
002$$

SCOTT BIN$sNwTpVReRAbgQ2QB DBD_ORA__DROP_ME YES YES
qMAHiw==$0

SCOTT SYS_IL0000107214C000 SYS_IL0000107214C00002$$ NO NO
02$$

SCOTT SYS_LOB0000107214C00 SYS_LOB0000107214C00002$$ NO NO
002$$

SCOTT BIN$sNwUFPboRAjgQ2QB DBD_ORA__DROP_ME YES YES
qMCUFA==$0

SCOTT SYS_IL0000107218C000 SYS_IL0000107218C00003$$ NO NO
03$$

SCOTT SYS_LOB0000107218C00 SYS_LOB0000107218C00003$$ NO NO
003$$

SCOTT BIN$sNwU0s+4RArgQ2QB DBD_ORA__DROP_ME YES YES
qMDWNg==$0

SCOTT SYS_IL0000107221C000 SYS_IL0000107221C00002$$ NO NO
02$$

SCOTT SYS_IL0000107221C000 SYS_IL0000107221C00003$$ NO NO
03$$

SCOTT SYS_IL0000107221C000 SYS_IL0000107221C00004$$ NO NO
04$$

SCOTT SYS_IL0000107221C000 SYS_IL0000107221C00005$$ NO NO
05$$

SCOTT SYS_LOB0000107221C00 SYS_LOB0000107221C00002$$ NO NO
002$$

SCOTT SYS_LOB0000107221C00 SYS_LOB0000107221C00003$$ NO NO
003$$

SCOTT SYS_LOB0000107221C00 SYS_LOB0000107221C00004$$ NO NO
004$$

SCOTT SYS_LOB0000107221C00 SYS_LOB0000107221C00005$$ NO NO
005$$

SCOTT BIN$sNwU58qqRAzgQ2QB DBD_ORA__DROP_ME YES YES
qMAOzg==$0

SCOTT BIN$sNwVC1JxRBjgQ2QB DBD_ORA__DROP_ME YES YES
qMBPiQ==$0

SCOTT BIN$sNwX+7oIRCTgQ2QB DBD_ORA__DROP_ME YES YES
qMCF/Q==$0

SCOTT BIN$sNwZmHenRC7gQ2QB DBD_ORA__DROP_ME YES YES
qMDFHA==$0


51 rows selected.

Elapsed: 00:00:00.12
SQL>

Everything can be cleaned manually, but I believe that the testing
procedure should run "purge recyclebin" at the end:
SQL> connect scott/tiger
Connected.
SQL> purge recyclebin;

Recyclebin purged.

Elapsed: 00:00:05.21


After that, there was nothing left:


SQL> select object_name,original_name,can_undrop,can_purge
2 from user_recyclebin;

no rows selected

Elapsed: 00:00:00.04
SQL>

perl -e 'use DBD::Oracle;print "$DBD::Oracle::VERSION\n";'
1.34

BTW, the Makefile.PL complained because of not being able to find demo.mk
but I circumvented it by using the instant client which was OK. My
version is 11.2.0.3 on Linux x86.

--
http://mgogala.byethost5.com

On Nov 5, 10:16*pm, Mladen Gogala <gogala.mla... (AT) gmail (DOT) com> wrote:

I think anything that leaves junk should clean up after itself, but
not any more than that.

jg
--
@home.com is bogus.
http://www.signonsandiego.com/news/2...to-local-fair/