Beefy Boxes and Bandwidth Generously Provided by pair Networks
Keep It Simple, Stupid

Re: Writing Oracle Stored Procedures in Perl

by smithers (Friar)
on Apr 11, 2009 at 17:25 UTC ( #757041=note: print w/replies, xml ) Need Help??

in reply to Writing Oracle Stored Procedures in Perl

What is your goal of finding a replacement language for Oracle PL/SQL? Explaining that may help.

Combining Perl and PL/SQL is very powerful as both are excellent languages and both are highly portable. Where there is Oracle (most platforms) there is PL/SQL. Why not use both languages and keep your procedural database code compiled/self-contained in the database as PL/SQL packages?

Are you trying to make your procedural database code vendor agnostic?

  • Comment on Re: Writing Oracle Stored Procedures in Perl

Replies are listed 'Best First'.
Re^2: Writing Oracle Stored Procedures in Perl
by kennethk (Abbot) on Apr 12, 2009 at 05:27 UTC
    Our primary motivation is leveraging an existing code-base and experience for internal functions. For example, we would like to migrate some data logic from our loaders, written in Perl, into triggers. Given some of the complexity in our data, using Perl in the data retrieval would be a blessing, but I am cynical about performance (but not prematurely optimizing).

    This is all underscored by a recent security policy handed down severely restricting what we can use as a front end. In particular, all code running between the database and the outside world must be Java or .NET and all custom code is strongly discouraged. I would like to emphasize we are not munging up display and data logic - I'm talking about ranking/grouping, complex constraints, ...

Log In?

What's my password?
Create A New User
Domain Nodelet?
Node Status?
node history
Node Type: note [id://757041]
and the web crawler heard nothing...

How do I use this?Last hourOther CB clients
Other Users?
Others examining the Monastery: (3)
As of 2023-12-10 07:34 GMT
Find Nodes?
    Voting Booth?
    What's your preferred 'use VERSION' for new CPAN modules in 2023?

    Results (38 votes). Check out past polls.