I have been successfully using Oracle database 11g R2 with SQL Developer and Forms 6i without encountering any errors. However, when attempting to connect with Python using the OracleDB library, I encountered the following error: DPY-3010: connections to this database server version are not supported by python-oracledb in thin mode. According to the Python-OracleDB documentation, it should be possible to connect 11g R2 with Python-OracleDB. I am seeking clarification on this issue and would appreciate any guidance on how to successfully connect 11g R2 with Python. Please provide the correct code for establishing the connection.

In erpnext, sales invoice doctype i want to opening&closing balance columns. how can i caluclate.opening and closing balance columns are not direct columns in sales invoice doctype.please provide the opening&closing balance sql query.

I have a stored procedure which will return a REF CURSOR containing a certain block of data:

I have an SP which will return a REF CURSOR containing a certain block of data:

I have an SP which will return a REF_OUT cursor containing a certain block of data:

I know that there’s is no phantom or non-repeatable read in serializable mode, but I received the task to obtain a similar effect with this level of isolation-during transaction 1, transaction 2 performs some actions that affect the results of the same query in transaction 1

I know that theres is no phantom or non-repetable read in SERIALIZABLE mode, but I received the task to obtain a similar effect with this level of isolation-during transaction 1, transaction 2 performs some actions that affect the results of the same query in transaction 1

I have 5 session between two date table name ABC

I have 5 session between two date table name ABC

Encountering this error while installing Oracle 19c