Ausführung und Abrufen des gespeicherten Verfahrens in Python mit Oracle DB zurückgeführt ⇐ Python

[Anonymous]

Ich versuche < /p>
auszuführen

Code: Select all

plsql = """
DECLARE
l_zip BLOB;
BEGIN
l_zip := apex_export.zip( p_source_files => apex_export.get_workspace(:1),
p_extra_files => apex_t_export_files( apex_t_export_file( name => 'README.md', contents => 'Merch Read Write Workspace Contents.'),
apex_t_export_file( name => 'LICENSE.txt', contents => 'The Universal Permissive License (UPL), Version 1.0'))
);
:2 := l_zip;
END;
"""

zip_var = cursor.var(oracledb.DB_TYPE_BLOB)

cursor.execute(plsql, [workspace_id, zip_var])

with open("workspace_export.zip", "wb") as f:
f.write(zip_data)

< /code>
Ich erhalte immer den Fehler < /p>
oracledb.exceptions.NotSupportedError: DPY-3002: Python value of type "tuple" is not supported

in the line     cursor.execute(plsql, [workspace_id, zip_var])