Stories
Slash Boxes
Comments
NOTE: use Perl; is on undef hiatus. You can read content, but you can't post it. More info will be forthcoming forthcomingly.

All the Perl that's Practical to Extract and Report

use Perl Log In

Log In

[ Create a new account ]

jdavidb (1361)

jdavidb
  (email not shown publicly)
http://voiceofjohn.blogspot.com/

J. David Blackstone has a Bachelor of Science in Computer Science and Engineering and nine years of experience at a wireless telecommunications company, where he learned Perl and never looked back. J. David has an advantage in that he works really hard, he has a passion for writing good software, and he knows many of the world's best Perl programmers.

Journal of jdavidb (1361)

Wednesday May 21, 2003
03:45 PM

Glue in Oracle

[ #12359 ]

Okay, we all know you have to glue things together. I can't seem to get a straight answer at work, so I thought I'd ask expert gluers: what's the simplest and most intelligent way to "shell out" of PL/SQL code? Note that I'm talking server-side stored PL/SQL code here; shelling out of SQL*Plus is useful but irrelevant for what I'm doing.

I highly suspect I'm not getting a straight answer because there's not one. If anyone's interested, I'll post how they're having me do it.

The Fine Print: The following comments are owned by whoever posted them. We are not responsible for them in any way.
 Full
 Abbreviated
 Hidden
More | Login | Reply
Loading... please wait.
  • ...but I was wrong. But there's always google [google.com]. Looks like there's no good direct way, but here's the best answer I could find [experts-exchange.com] (summary: Java, DBMS_PIPE w/a daemon, or compile something into a shared library).
  • Here's what I've found, so far (havent tried any of this on 9i, so no idea if things are different)

    Java: nice.. if you like coding java, this is by far the easiest method to do things.. but of course, its err... java (does my bias show yet ?), and Oracle only allows you to use a weird JVM called Aurora (not the standard JVM by Sun), so you may find some class libraries arent there.. Compatibility is with 1.1.8, I think)

    Shared library: compile the C equivalent of what you want done into a shared object (or