Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: SQL Trace Profiler
On 09/26/2005 02:34:50 PM, Gogala, Mladen wrote:
> I tried it and I like it. The only thing that I keep nagging about is the
> fact that it is not written in the Only Proper Scripting Language(TM),
> but is written in Python instead. Fortunately, there is a good thing
> for converting the infidels on http://perthon.sourceforge.net
> I'll try whether it works on ORaSRP and let you know if it works.
> God is great and Larry Wall is his prophet!
> --
> Mladen Gogala
> Ext. 121
Unfortunately, I am unable to make it work with perl translator: $ perl perthon.pl ex/orasrp.py
ERROR (line 32): Invalid file input: Was expecting end of file but found "import sys,re,getopt,time" instead
First, I needed an additional module, which wasn't much of a problem:
$ perl perthon.pl ex/orasrp.py
Can't locate Parse/RecDescent.pm in @INC
CPAN took care of it:
cpan> install Parse::RecDescent
CPAN: Storable loaded ok
Going to read /root/.cpan/Metadata
Database was generated on Sat, 20 Aug 2005 03:07:50 GMT
CPAN: LWP::UserAgent loaded ok
Fetching with LWP:
ftp://cpan.cs.utah.edu/pub/CPAN/authors/01mailrc.txt.gz
Going to read /root/.cpan/sources/authors/01mailrc.txt.gz
CPAN: Compress::Zlib loaded ok
Fetching with LWP:
ftp://cpan.cs.utah.edu/pub/CPAN/modules/02packages.details.txt.gz
Going to read /root/.cpan/sources/modules/02packages.details.txt.gz
Database was generated on Mon, 26 Sep 2005 10:01:08 GMT
Fetching with LWP:
ftp://cpan.cs.utah.edu/pub/CPAN/modules/03modlist.data.gz
Going to read /root/.cpan/sources/modules/03modlist.data.gz
Going to write /root/.cpan/Metadata
Running install for module Parse::RecDescent
Running make for D/DC/DCONWAY/Parse-RecDescent-1.94.tar.gz
Fetching with LWP:
ftp://cpan.cs.utah.edu/pub/CPAN/authors/id/D/DC/DCONWAY/Parse-RecDescent-1.94.tar.gz
CPAN: Digest::MD5 loaded ok
Fetching with LWP:
ftp://cpan.cs.utah.edu/pub/CPAN/authors/id/D/DC/DCONWAY/CHECKSUMS
Checksum for /root/.cpan/sources/authors/id/D/DC/DCONWAY/Parse-RecDescent-1.94.tar.gz ok
Scanning cache /root/.cpan/build for sizes
Parse-RecDescent-1.94/ Parse-RecDescent-1.94/Changes Parse-RecDescent-1.94/demo/ Parse-RecDescent-1.94/demo/demo_autoscoresep.pl Parse-RecDescent-1.94/demo/demo_bad.pl Parse-RecDescent-1.94/demo/demo_buildcalc.pl Parse-RecDescent-1.94/demo/demo_calc.pl Parse-RecDescent-1.94/demo/demo_Cgrammar.pl Parse-RecDescent-1.94/demo/demo_cpp.pl Parse-RecDescent-1.94/demo/demo_decomment.pl Parse-RecDescent-1.94/demo/demo_decomment_nonlocal.pl Parse-RecDescent-1.94/demo/demo_delete.pl Parse-RecDescent-1.94/demo/demo_derived.pl Parse-RecDescent-1.94/demo/demo_errors.pl Parse-RecDescent-1.94/demo/demo_implicit.pl Parse-RecDescent-1.94/demo/demo_language.pl Parse-RecDescent-1.94/demo/demo_leftassoc.pl Parse-RecDescent-1.94/demo/demo_leftop.pl Parse-RecDescent-1.94/demo/demo_lexer.pl Parse-RecDescent-1.94/demo/demo_lisplike.pl Parse-RecDescent-1.94/demo/demo_logic.pl Parse-RecDescent-1.94/demo/demo_matchrule.pl Parse-RecDescent-1.94/demo/demo_mccoy.pl Parse-RecDescent-1.94/demo/demo_methods.pl Parse-RecDescent-1.94/demo/demo_NL2SQL Parse-RecDescent-1.94/demo/demo_OOparsetree.pl Parse-RecDescent-1.94/demo/demo_operator.pl Parse-RecDescent-1.94/demo/demo_parsetree.pl Parse-RecDescent-1.94/demo/demo_piecewise.pl Parse-RecDescent-1.94/demo/demo_precalc.pl Parse-RecDescent-1.94/demo/demo_randomsentence.pl Parse-RecDescent-1.94/demo/demo_recipe.pl Parse-RecDescent-1.94/demo/demo_restructure_easy.pl Parse-RecDescent-1.94/demo/demo_restructure_painful.pl Parse-RecDescent-1.94/demo/demo_scoredsep.pl Parse-RecDescent-1.94/demo/demo_selfmod.pl Parse-RecDescent-1.94/demo/demo_separators.pl Parse-RecDescent-1.94/demo/demo_simple.pl Parse-RecDescent-1.94/demo/demo_simplequery.pl Parse-RecDescent-1.94/demo/demo_simpleXML.pl Parse-RecDescent-1.94/demo/demo_template.pl Parse-RecDescent-1.94/demo/demo_textgen.pl Parse-RecDescent-1.94/demo/demo_whoson.pl Parse-RecDescent-1.94/lib/ Parse-RecDescent-1.94/lib/Parse/ Parse-RecDescent-1.94/lib/Parse/RecDescent.pm Parse-RecDescent-1.94/lib/Parse/RecDescent.pod Parse-RecDescent-1.94/Makefile.PL Parse-RecDescent-1.94/MANIFEST Parse-RecDescent-1.94/README Parse-RecDescent-1.94/test.pl Parse-RecDescent-1.94/tutorial/ Parse-RecDescent-1.94/tutorial/TPJ-PRD-proc.gif Parse-RecDescent-1.94/tutorial/TPJ-yacc-proc.gif Parse-RecDescent-1.94/tutorial/TPJ_maze.gif Parse-RecDescent-1.94/tutorial/TPJ_tree.gif Parse-RecDescent-1.94/tutorial/tutorial.html
CPAN.pm: Going to build D/DC/DCONWAY/Parse-RecDescent-1.94.tar.gz
Checking if your kit is complete...
Looks good
Writing Makefile for Parse::RecDescent
cp lib/Parse/RecDescent.pod blib/lib/Parse/RecDescent.pod
cp lib/Parse/RecDescent.pm blib/lib/Parse/RecDescent.pm
Manifying blib/man3/Parse::RecDescent.3pm
/usr/bin/make -- OK
Running make test
PERL_DL_NONLAZY=1 /usr/bin/perl "-Iblib/lib" "-Iblib/arch" test.pl
1..18
ok 1
ok 2
ok 3
ok 4
ok 5
ok 6
ok 7
ok 8
ok 9
ok 10
ok 11
ok 12
ok 13
ok 14
ok 15
ok 16
ok 17
ok 18
/usr/bin/make test -- OK
Running make install
Installing /usr/lib/perl5/site_perl/5.8.5/Parse/RecDescent.pod Installing /usr/lib/perl5/site_perl/5.8.5/Parse/RecDescent.pm Installing /usr/share/man/man3/Parse::RecDescent.3pmWriting /usr/lib/perl5/site_perl/5.8.5/i386-linux-thread-multi/auto/Parse/RecDescent/.packlist Appending installation info to /usr/lib/perl5/5.8.5/i386-linux-thread-multi/perllocal.pod /usr/bin/make install -- OK
cpan>
Now "perthon" modules compiled correctly:
$ perl -c lib/Perthon/*
lib/Perthon/Perthon.pm syntax OK
Still, I cannot translate Python to Perl. One of these days I'll have to do a manual rewrite. Shame.
-- Mladen Gogala http://www.mgogala.com -- http://www.freelists.org/webpage/oracle-lReceived on Mon Sep 26 2005 - 18:43:41 CDT
![]() |
![]() |