Ausführung und Abrufen des gespeicherten Verfahrens in Python mit Oracle DB zurückgeführt
Posted: 14 Apr 2025, 00:37
Ich versuche < /p>
auszuführen
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])