Search notes:

cx_Oracle and SQLAlchemy

import sqlalchemy
import os
import pandas
 
db_user = 'rene'
db_pw   = 'xxx'
db_env  = 'oradb'
 
eng = sqlalchemy.create_engine(f'oracle+cx_oracle://{db_user}:{db_pw}@{db_env}')
 
with eng.connect() as con:
     df = pandas.read_sql_query(sqlalchemy.text('select object_name, object_type txt from user_objects'), con)
     print(df);

See also

cx_Oracle

Index

Fatal error: Uncaught PDOException: SQLSTATE[HY000]: General error: 8 attempt to write a readonly database in /home/httpd/vhosts/renenyffenegger.ch/php/web-request-database.php:78 Stack trace: #0 /home/httpd/vhosts/renenyffenegger.ch/php/web-request-database.php(78): PDOStatement->execute(Array) #1 /home/httpd/vhosts/renenyffenegger.ch/php/web-request-database.php(30): insert_webrequest_('/notes/developm...', 1759397783, '216.73.216.42', 'Mozilla/5.0 App...', NULL) #2 /home/httpd/vhosts/renenyffenegger.ch/httpsdocs/notes/development/languages/Python/libraries/cx_Oracle/SQLAlchemy(47): insert_webrequest() #3 {main} thrown in /home/httpd/vhosts/renenyffenegger.ch/php/web-request-database.php on line 78