Oracle errors in Express Edition 21

[RichardJECooke]

https://github.com/lerocha/chinook-database/blob/master/ChinookDatabase/DataSources/Chinook_Oracle.sql

SQL Error [900] [42000]: ORA-00900: invalid SQL statement

  Error : 900, Position : 0, Sql = conn chinook/p4ssw0rd


/*******************************************************************************
   Create Tables
********************************************************************************/
CREATE TABLE Album
(
    AlbumId NUMBER NOT NULL,
    Title VARCHAR2(160) NOT NULL,
    ArtistId NUMBER NOT NULL,
    CONSTRAINT PK_Album PRIMARY KEY  (AlbumId)
), OriginalSql = conn chinook/p4ssw0rd


/*******************************************************************************
   Create Tables
********************************************************************************/
CREATE TABLE Album
(
    AlbumId NUMBER NOT NULL,
    Title VARCHAR2(160) NOT NULL,
    ArtistId NUMBER NOT NULL,
    CONSTRAINT PK_Album PRIMARY KEY  (AlbumId)
), Error Msg = ORA-00900: invalid SQL statement

  ORA-00900: invalid SQL statement

[lerocha]

Thank you for reporting the issue! The script has been fixed.

[udaybuie]

@RichardJECooke
i am new to python and struggling to find installation steps for Oracle db and fetching data from it.
its well elaborative for sqlite and i have tried these from this link https://python.langchain.com/docs/use_cases/sql/agents, it worked like a charm.

can you please provide details steps of which database tool you used for oracle to import the Chinook_Oracle.sql and the fetch code as well, as i don't see any oracle related class in langchain_community.utilities. or can you please share some link please, which i can follow?