Re: [PBML] Perl/crystal reports
- What database are you running? Stored procedures, and the methods for
extending them with non-SQL languages, are all platform specific.
Performance may be a concern.
Postgres has by far the best solution: <a
href="http://en.wikipedia.org/wiki/PL/Perl">PL/Perl</a>. This allows
you to run a non-trivial subset of Perl as a Postgres Stored Procedure.
In Sybase and MS-SQL, you can use xp_cmdshell or a custom extended
stored procedure. I'm sure Oracle has a similar method, but I'm not
familiar with it.
I don't know of a solution for MySQL. MySQL historically has been
hostile to the idea of stored procedures and adopted them reluctantly.
On 04/11/2012 10:02 AM, zenithstar.websites wrote:
> Hi Perl experts,
> I have used perl for a few years and I would like to incorporate perl
> in an existing reporting framework. How it currently exists is that we
> Stored procs(sql server) and all the calculation is done in the stored
> proc and output is sent to crystal report .
> Is there a way to embed perl inside the stored procedure. I want to
> utilize the perl pattern matching features with the data inside the
> stored proc. Any hints?
[Non-text portions of this message have been removed]