Possible to run Python scripts from oracle?

[dglass]

Unfortunately, it doesn't display anything different. It seems that an error will occur on the first "command?" line. Example with just print:

Error:
Error report -
ORA-27369: job of type EXECUTABLE failed with exit code: 1   File "C:\test.py", line 2
    print 'Hello, world!'

(Error code 1 is just the generic "everything else" error code)

With the script I was using:

import sys
import traceback
def main():
   f= open("test.txt","w+")
   for i in range(10):
         f.write("This is line %d\r\n" % (i+1))
   f.close()
if __name__ == '__main__':
    try:
        main()
    except Exception:
        s = ''.join(traceback.format_exc(-3)).replace('\n', ' ')  # or -2
        print(s, file=sys.stderr)
        sys.exit(1)

Gets this:

Error:
Error report -
ORA-27369: job of type EXECUTABLE failed with exit code: 1 Traceback (most recent call last):   File "C:\test.py", line 10, in <module>