Using Perl with Oracle 10G on Windows

[Bob T]

I have used Perl for a long time, and it is the only language I use to
do Windows command scripting. I have always used the Perl version
from Activstate.com. Now that Oracle is delivered with a version of
Perl, I am running into compatibility problems.

I would like to try using only the Perl that comes with oracle, so that
I don't introduce version problems.

I tried to use the windows gui tool to assign the files of type *.pl to
the perl program in:
#D:\oracle\product\10.1.0\Db_1\perl\5.6.1\bin\MSWin32-x86\perl.exe
For some reason unknown to me, I click on a file named test.pl, I
browse for the program to open it with, go to the perl.exe, click on
Open, but when I get back to the window that is supposed to create the
file association, the perl file doesn't show up.

I need to be able to associate files of type *.pl with the perl
program.
Does anyone knwo what I need to do so that I can call a perl program
from a command line and have it find and use the version from Oracle?

ByTheWay, I know windows sux, so spare me the lectures on that topic,
please.

Thanks for any help or pointers to resources...
Bob Treumann

[Rauf Sarwar]

Bob T wrote: I have used Perl for a long time, and it is the only language I use to do Windows command scripting. I have always used the Perl version from Activstate.com. Now that Oracle is delivered with a version of Perl, I am running into compatibility problems. I would like to try using only the Perl that comes with oracle, so that I don't introduce version problems. I tried to use the windows gui tool to assign the files of type *.pl to the perl program in: #D:\oracle\product\10.1.0\Db_1\perl\5.6.1\bin\MSWin32-x86\perl.exe For some reason unknown to me, I click on a file named test.pl, I browse for the program to open it with, go to the perl.exe, click on Open, but when I get back to the window that is supposed to create the file association, the perl file doesn't show up. I need to be able to associate files of type *.pl with the perl program. Does anyone knwo what I need to do so that I can call a perl program from a command line and have it find and use the version from Oracle? ByTheWay, I know windows sux, so spare me the lectures on that topic, please. Thanks for any help or pointers to resources... Bob Treumann

1) Open Windows explorer
2) On the menu click Tools -> Folder Options...
3) Click on File Types
4) Click on New then add PL and Ok
5) Click on Change and browse for perl.exe
6) Ok

Regards
/Rauf

[Mark Bole]

Rauf Sarwar wrote: Bob T wrote:
[...]I would like to try using only the Perl that comes with oracle, so thatI don't introduce version problems.
[...]I need to be able to associate files of type *.pl with the perlprogram.Does anyone knwo what I need to do so that I can call a perl programfrom a command line and have it find and use the version from Oracle?
[...] 1) Open Windows explorer 2) On the menu click Tools -> Folder Options...
[...]

This is more of a Perl question than an Oracle question, so I've removed
the cross-posting to multiple groups, at least.

Try the following built-in Windows command, which conveniently tells you
what to do for Perl scripts:

ftype /?

Or, in the following directory for your Oracle install, try the
pl2bat.bat file

Oracle\product\10.1.0\db_1\perl\5.6.1\bin\pl2bat.bat

This will allow you to explicitly put the fully qualified path of the
perl executable you wish to use directly in your script, just like the
shebang (#!) facility of most Unix shells.

-Mark Bole