# OracleAutonomousDatabaseLoader

> **Class** in `langchain_community`

📖 [View in docs](https://reference.langchain.com/python/langchain-community/document_loaders/oracleadb_loader/OracleAutonomousDatabaseLoader)

Load from oracle adb

Autonomous Database connection can be made by either connection_string
or tns name. wallet_location and wallet_password are required
for TLS connection.
Each document will represent one row of the query result.
Columns are written into the `page_content` and 'metadata' in
constructor is written into 'metadata' of document,
by default, the 'metadata' is None.

## Signature

```python
OracleAutonomousDatabaseLoader(
    self,
    query: str,
    user: str,
    password: str,
    *,
    schema: Optional[str] = None,
    tns_name: Optional[str] = None,
    config_dir: Optional[str] = None,
    wallet_location: Optional[str] = None,
    wallet_password: Optional[str] = None,
    connection_string: Optional[str] = None,
    metadata: Optional[List[str]] = None,
    parameters: Optional[Union[list, tuple, dict]] = None,
)
```

## Extends

- `BaseLoader`

## Constructors

```python
__init__(
    self,
    query: str,
    user: str,
    password: str,
    *,
    schema: Optional[str] = None,
    tns_name: Optional[str] = None,
    config_dir: Optional[str] = None,
    wallet_location: Optional[str] = None,
    wallet_password: Optional[str] = None,
    connection_string: Optional[str] = None,
    metadata: Optional[List[str]] = None,
    parameters: Optional[Union[list, tuple, dict]] = None,
)
```

| Name | Type |
|------|------|
| `query` | `str` |
| `user` | `str` |
| `password` | `str` |
| `schema` | `Optional[str]` |
| `tns_name` | `Optional[str]` |
| `config_dir` | `Optional[str]` |
| `wallet_location` | `Optional[str]` |
| `wallet_password` | `Optional[str]` |
| `connection_string` | `Optional[str]` |
| `metadata` | `Optional[List[str]]` |
| `parameters` | `Optional[Union[list, tuple, dict]]` |


## Properties

- `query`
- `user`
- `password`
- `schema`
- `tns_name`
- `config_dir`
- `wallet_location`
- `wallet_password`
- `connection_string`
- `metadata`
- `parameters`
- `dsn`

## Methods

- [`load()`](https://reference.langchain.com/python/langchain-community/document_loaders/oracleadb_loader/OracleAutonomousDatabaseLoader/load)

## ⚠️ Deprecated

Deprecated since version 0.3.30.

---

[View source on GitHub](https://github.com/langchain-ai/langchain-community/blob/a6a6079511ac8a5c1293337f88096b8641562e77/libs/community/langchain_community/document_loaders/oracleadb_loader.py#L9)