<p class="MsoNormal"><span lang="EN-US" style="font-size:10.0pt;mso-bidi-font-size:
11.0pt;font-family:"Verdana","sans-serif";mso-ansi-language:EN-US">Hi all,</span></p>

<p class="MsoNormal"><span lang="EN-US" style="font-size:10.0pt;mso-bidi-font-size:
11.0pt;font-family:"Verdana","sans-serif";mso-ansi-language:EN-US"> </span></p>

<p class="MsoNormal"><span lang="EN-US" style="font-size:10.0pt;mso-bidi-font-size:
11.0pt;font-family:"Verdana","sans-serif";mso-ansi-language:EN-US">   I wrote a simple Java program to be called
within an Oracle database. The goal is to execute a Python program within the
DB itself, by the means of a Java program. The problem is that when I execute
the procedure inside the DB, nothing happens…</span></p>

<p class="MsoNormal"><span lang="EN-US" style="font-size:10.0pt;mso-bidi-font-size:
11.0pt;font-family:"Verdana","sans-serif";mso-ansi-language:EN-US"> </span></p>

<p class="MsoNormal"><span lang="EN-US" style="font-size:10.0pt;mso-bidi-font-size:
11.0pt;font-family:"Verdana","sans-serif";mso-ansi-language:EN-US">   If I create the same Java class outside the
DB and execute it, the python program works perfectly, only inside the DB
nothing happens. The program is the following.</span></p>

<p class="MsoNormal"><span lang="EN-US" style="font-size:10.0pt;mso-bidi-font-size:
11.0pt;font-family:"Verdana","sans-serif";mso-ansi-language:EN-US"> </span></p>

<p class="MsoNormal"><span lang="EN-US">CREATE OR
REPLACE AND COMPILE java source named "OSCommand" as</span></p>

<p class="MsoNormal"><span lang="EN-US">import
java.io.*;</span></p>

<p class="MsoNormal"><span lang="EN-US">public
class OSCommand{</span></p>

<p class="MsoNormal"><span lang="EN-US">public
static void Run(){</span></p>

<p class="MsoNormal"><span lang="EN-US">try </span></p>

<p class="MsoNormal"><span lang="EN-US">        {</span></p>

<p class="MsoNormal"><span lang="EN-US">            Runtime r = Runtime.getRuntime();</span></p>

<p class="MsoNormal"><span lang="EN-US">            Process p = r.exec("cmd /c
C:\\Python32\\python.exe C:\\Ficheiros\\SAP\\Novos\\xls2csv.py
C:\\Ficheiros\\SAP\\Novos\\20111020_ListagemSAP.xlsx");</span></p>

<p class="MsoNormal"><span lang="EN-US"> </span></p>

<p class="MsoNormal"><span lang="EN-US">        } </span></p>

<p class="MsoNormal"><span lang="EN-US">        catch (Exception e) </span></p>

<p class="MsoNormal"><span lang="EN-US">        {</span></p>

<p class="MsoNormal"><span lang="EN-US">            e.printStackTrace();</span></p>

<p class="MsoNormal"><span lang="EN-US">        }</span></p>

<p class="MsoNormal"><span lang="EN-US">        }</span></p>

<p class="MsoNormal"><span lang="EN-US">}</span></p>

<p class="MsoNormal"><span lang="EN-US">/</span></p>

<p class="MsoNormal"><span lang="EN-US"> </span></p>

<p class="MsoNormal"><span lang="EN-US">   Can anyone help?</span></p>

<p class="MsoNormal"><span lang="EN-US"> </span></p>

<p class="MsoNormal"><span lang="EN-US">Thanks,</span></p>

<p class="MsoNormal"><span lang="EN-US">André</span></p>