Boolean Parameter Support

[omair2084]

I have tested this to work fine on Oracle 11 XE.

Here is the issue: The boolean parameter causes an error.

>>> parameters = {'job_action': '/usr/bin/python', 'number_of_arguments': 2, 'job_type': 'EXECUTABLE', 'job_name': 'test'}
>>> cur.callproc(name="DBMS_SCHEDULER.create_job",keywordParameters=parameters)
['/usr/bin/python', 2, 'EXECUTABLE', 'test']

If we have the boolean value

>>> parameters = {'job_action': '/usr/bin/python', 'number_of_arguments': 2, 'job_type': 'EXECUTABLE', 'auto_drop':False, 'job_name': 'test'}
>>> cur.callproc(name="DBMS_SCHEDULER.create_job",keywordParameters=parameters)
Traceback (most recent call last):
  File "<stdin>", line 1, in <module>
cx_Oracle.DatabaseError: ORA-03115: unsupported network datatype or representation

Since it works fine without the auto_drop value, I would suggest to remove it.

[quentinhardy]

I will check that as soon as possible.

[quentinhardy]

Hi,

Can you create an option in main module (e.g. --auto-drop) ? With this option, the user could manage this auto_drop parameter from command line.

If you can't, I will create this option in this DbmsScheduler module as soon as possible.

Keep me up-to-date,