[DB-SIG] External procedure

Andy Todd andy47 at halfcooked.com
Fri Nov 11 09:15:04 CET 2005


Lucas Alvarez wrote:
> Hi All,
> I want to create a trigger that runs a python script, is that possible? 
> I'm using oracle 9i.
> I would appreciate any help, thanks in advance.
> 
> Lucas Alvarez
> 
> _______________________________________________
> DB-SIG maillist  -  DB-SIG at python.org
> http://mail.python.org/mailman/listinfo/db-sig

Oracle stored procedures can be developed in either PL/SQL or Java. 
That's about it I'm afraid.

You can, of course, write Python programs that access Oracle databases 
but sadly there is currently no way of making them run natively in the 
database. As Marc-Andre suggested you could think about developing your 
code in Jython but it would have to be turned into Java bytecode before 
you loaded it into Oracle, which rather defeats the purpose I fear.

Although, correcting myself, if you want to upgrade to Oracle 10.2 and 
only run on Windows you can develop stored procedures in any language 
that runs on the CLR;

http://www.oracle.com/technology/pub/articles/mastering_dotnet_oracle/williams_sps.html

Regards,
Andy
-- 
--------------------------------------------------------------------------------
 From the desk of Andrew J Todd esq - http://www.halfcooked.com/


More information about the DB-SIG mailing list