---
title: "Validation Query Throwing Oracle Exception"
canonical: "https://support.appfire.com/space/SQL/74321683/Validation%20Query%20Throwing%20Oracle%20Exception"
format: markdown
---
> Macro (aura-html)

# Symptoms

One or more SQL Macro returns the following error:

```
org.apache.tomcat.dbcp.dbcp.SQLNestedException:
Cannot create PoolableConnectionFactory (ORA-00923: FROM keyword not found where expected
```

## Cause

<span style="color: #333333">Oracle requires a</span><span style="color: #333333"> </span>**FROM**<span style="color: #333333"> </span><span style="color: #333333">clause on the validation query. Most other databases it is sufficient to use</span><span style="color: #333333"> </span>**SELECT 1**<span style="color: #333333">. </span>

## Resolution

<span style="color: #333333">Add a valid </span>**<span style="color: #333333">FROM</span>**<span style="color: #333333"> clause for Oracle</span>.