Multiple bind variables with custom types in oracledb Python

Asked Jun 30 '23 at 17:55

Active Jun 30 '23 at 17:55

Viewed 43 times

So, I'm working in a project that haves multiple output vars for stored procedures, but the types of the vars are custom, with oracledb library to declare the output bind variable you have to call:

cursor.var(oracledb.OBJECT, typename='custom_type_name')

but calling that makes the library fetch type info from db, so here comes the problem, if you have like 50 bind variables with custom types python have to make 50 request to db and that translates to 50 seconds of execution time, how can I improve that?

I tried multithreading and the results are the same.

asked Jun 30 '23 at 17:55

abvega

1

Are all of the types different? – Anthony Tuininga Jun 30 '23 at 19:00
Yes, they are different. – abvega Jun 30 '23 at 19:02
1

Then there is currently no way to improve that. But it shouldn't take a second for each one unless you have high latency in your connection to the database! – Anthony Tuininga Jul 01 '23 at 02:00
1

Try and do as much processing as possible in PL/SQL to minimize type and data transfers to Python. – Christopher Jones Jul 02 '23 at 23:51

Multiple bind variables with custom types in oracledb Python

0 Answers0