Re: Execute python within Oracle

Path	csiph.com!x330-a1.tempe.blueboxinc.net!usenet.pasdenom.info!news.albasani.net!newsfeed.freenet.ag!news2.euro.net!newsgate.cistron.nl!newsgate.news.xs4all.nl!post.news.xs4all.nl!not-for-mail
Return-Path	<ian.g.kelly@gmail.com>
X-Original-To	python-list@python.org
Delivered-To	python-list@mail.python.org
X-Spam-Status	OK 0.084
X-Spam-Evidence	'H': 0.83; 'S': 0.00; 'permissions': 0.04; 'python': 0.08; 'subject:python': 0.10; 'andr\xe9': 0.16; 'happens.': 0.16; 'cheers,': 0.20; 'java': 0.21; 'wrote': 0.22; 'header:In-Reply-To:1': 0.22; 'changed': 0.23; 'itself,': 0.23; "i'm": 0.26; 'all,': 0.28; 'message-id:@mail.gmail.com': 0.28; 'oracle': 0.29; 'problem': 0.29; 'class': 0.29; 'received:209.85.161.46': 0.32; 'received:mail- fx0-f46.google.com': 0.32; 'to:addr:python-list': 0.34; 'then.': 0.34; 'received:209.85.161': 0.36; 'received:google.com': 0.37; 'received:209.85': 0.38; 'called': 0.40; 'received:209': 0.40; 'to:addr:python.org': 0.40; 'might': 0.40; 'within': 0.60; 'url:p': 0.62; 'url:11': 0.64; 'url:0': 0.67; 'granted': 0.68; 'url:f': 0.73; 'article': 0.74; 'database.': 0.74; 'following.': 0.91
DKIM-Signature	v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=mime-version:in-reply-to:references:from:date:message-id:subject:to :content-type:content-transfer-encoding; bh=wSooVoytI6Q7sPkz1VKi546gtcAo+CeNGEuKQGf/oNU=; b=bpaaylhD9YgtgB69UY4Q5fSi5SWcLE5iOCw2gAGmIJX5YvlWeBNqr2n5Jms2xsG9xB dOM478PjtGFQowvBPVQ+ITlRbjLWHTW679AqcpFri0igoUQ8gVu1Q45SjLTMov5+w7TP gPkbsLikp4Eo4KtZYapH/GaKq0ABlFN0cmyBk=
MIME-Version	1.0
In-Reply-To	<CAAcacLznfsp2_ftrD5RbE1ppNUiz5JmmnH5c5BWJ1sXDtK6RVA@mail.gmail.com>
References	<CAAcacLznfsp2_ftrD5RbE1ppNUiz5JmmnH5c5BWJ1sXDtK6RVA@mail.gmail.com>
From	Ian Kelly <ian.g.kelly@gmail.com>
Date	Fri, 9 Dec 2011 10:50:31 -0700
Subject	Re: Execute python within Oracle
To	Python <python-list@python.org>
Content-Type	text/plain; charset=windows-1252
Content-Transfer-Encoding	quoted-printable
X-BeenThere	python-list@python.org
X-Mailman-Version	2.1.12
Precedence	list
List-Id	General discussion list for the Python programming language <python-list.python.org>
List-Unsubscribe	<http://mail.python.org/mailman/options/python-list>, <mailto:python-list-request@python.org?subject=unsubscribe>
List-Archive	<http://mail.python.org/pipermail/python-list>
List-Post	<mailto:python-list@python.org>
List-Help	<mailto:python-list-request@python.org?subject=help>
List-Subscribe	<http://mail.python.org/mailman/listinfo/python-list>, <mailto:python-list-request@python.org?subject=subscribe>
Newsgroups	comp.lang.python
Message-ID	<mailman.3481.1323453069.27778.python-list@python.org> (permalink)
Lines	30
NNTP-Posting-Host	2001:888:2000:d::a6
X-Trace	1323453069 news.xs4all.nl 6893 [2001:888:2000:d::a6]:33629
X-Complaints-To	abuse@xs4all.nl
Xref	x330-a1.tempe.blueboxinc.net comp.lang.python:16926

Show key headers only | View raw

2011/12/9 André Lopes <andrecrash3r@gmail.com>:
> Hi all,
>
>
>
>    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…
>
>
>
>    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.

Have you granted the necessary permissions to execute programs from Java?

http://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:952229840241

Note that article is for Oracle 8, I'm not sure whether the
permissions might have changed since then.

Cheers,
Ian

Back to comp.lang.python | Previous | Next | Find similar | Unroll thread

Thread

Re: Execute python within Oracle Ian Kelly <ian.g.kelly@gmail.com> - 2011-12-09 10:50 -0700

csiph-web