Forum Stats

  • 3,816,303 Users
  • 2,259,168 Discussions
  • 7,893,449 Comments

Discussions

Embedded Python Execution on Always Free ADB

YuriAP
YuriAP Member Posts: 51 Blue Ribbon
edited Dec 15, 2021 6:17AM in Machine Learning

Hello

Do I understand correctly that "Embedded Python Execution" is not supported on ADB Free Tier?

I get for example

ORA-04043: object PYQSYS.pyqEval does not exist

On both 19c and 21c ADB.

DBA_OBJECTS does not show anything like " upper(object_name) like 'PYQ%EVAL%' "

Answers

  • User_QFLVG
    User_QFLVG Member Posts: 2 Green Ribbon

    Did you get it working? I am trying to get the example 8.11 at

    to work and it even fails on the fully paid Database.

    In fact I can't even get Hello World to worK;

    Trying to Store a User Defined Python Function in Oracle Machine Learning Script Repository.

    The below function exists and runs in OML.

    %python

    import oml

    def TestRepo ():

    print ("Hello World")

    return

    When I try to store it in the repository with the below command it fails:

    oml.script.create(name = "TEST", func = TestRepo, overwrite = True, is_global = True)

    The Error appears below:

    Fail to execute line 40: oml.script.create(name = "TEST", func = TestRepo, overwrite = True, is_global = True)

    Traceback (most recent call last):

    File "/tmp/1643972373269-0/zeppelin_python.py", line 200, in <module>

    exec(code, _zcUserQueryNameSpace)

    File "<stdin>", line 40, in <module>

    File "oml/script/script.py", line 148, in oml.script.script.create

    File "oml/script/script.py", line 328, in oml.script.script._deparseFun

    File "/usr/local/lib/python3.9/inspect.py", line 1024, in getsource

    lines, lnum = getsourcelines(object)

    File "/usr/local/lib/python3.9/inspect.py", line 1006, in getsourcelines

    lines, lnum = findsource(object)

    File "/usr/local/lib/python3.9/inspect.py", line 835, in findsource

    raise OSError('could not get source code')

    OSError: could not get source code