All Questions
Tagged with python-oracledb database
6 questions
0
votes
1
answer
270
views
python-oracledb User-Defined Exception
I am executing a PL/SQL procedure from Python, and the procedure returns a user-defined exception. However, I am not getting the exception code and message that are defined in the PL/SQL package. How ...
- 73
0
votes
0
answers
185
views
How do I create and use PL/SQL packages with python-oracledb? Getting error PLS-00905
I am having difficulty using packages with python-oracledb. My code is as follows.
def package_basic(cur):
cur.callproc("dbms_output.enable")
cur.execute("""
...
- 33
0
votes
1
answer
1k
views
Oracle Database query results in "ValueError: year XXXX is out of range" error while fetching data from a datetime column
import pandas as pd
from io import StringIO
import boto3
import json
import datetime
import oracledb
import os
def DateTimeConverter(value):
if value.year > 9999:
return datetime....
5
votes
2
answers
21k
views
With python-oracledb what does 'DPY-4027: no configuration directory to search for tnsnames.ora' mean
With the python-oracledb driver the code:
import oracledb
cs = "MYDB"
c = oracledb.connect(user='cj', password=mypw, dsn=cs)
gives the error:
oracledb.exceptions.DatabaseError: DPY-4027: ...
- 10.9k
0
votes
1
answer
822
views
What does "TypeError: connect() got multiple values for argument 'dsn'" with python-oracledb mean?
The python-oracledb code:
import oracledb
import os
un = os.environ.get("PYTHON_USERNAME")
pw = os.environ.get("PYTHON_PASSWORD")
cs = "localhost/orclpdb1"
c = oracledb....
- 10.9k
2
votes
1
answer
17k
views
Error DPY-3010 when connecting python-oracledb to Oracle DB 11.2
If I try to connect to Oracle Database 11.2 using python-oracledb's default
'Thin' mode I get the error:
DPY-3010: connections to this database server version are not supported by python-oracledb in ...
- 10.9k