# sql command not properly ended error from oracle when i run a query with jinja syntax in it.

**URL:** <https://discourse.getdbt.com/t/sql-command-not-properly-ended-error-from-oracle-when-i-run-a-query-with-jinja-syntax-in-it/10247>\
**Category:** Help\
**Created:** [October 6, 2023, 3:59pm UTC](https://discourse.getdbt.com/t/sql-command-not-properly-ended-error-from-oracle-when-i-run-a-query-with-jinja-syntax-in-it/10247 "2023-10-06T15:59:38Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![saeed](https://avatars.discourse-cdn.com/v4/letter/s/e8c25b/32.png) [@saeed](https://discourse.getdbt.com/u/saeed)\
**Post date:** [October 6, 2023, 3:59pm UTC](https://discourse.getdbt.com/t/sql-command-not-properly-ended-error-from-oracle-when-i-run-a-query-with-jinja-syntax-in-it/10247/1 "2023-10-06T15:59:38Z")

</div>

I get the error message as below when i execute my query having jinja syntax. what is causing this?. I already have ‘test’ model in my database which is being created by running my modle in dbt. The error message: ora-0093 : SQL command not properly ended .  
details : {“code”: -1, “message”: SQL command not properly ended\n}

```auto
Here is my model:
with first as

(select * from {{ ref("test") }} ) 

select * from first

compiled to :

with first as
(select * from my-user-name.test ) 
select * from first

Note: When i run the compiled querry in sql developer , it works but it gives me error message if i run it in vscode with dbt power user extention or Jinja-sql. if i try to run it with oracle pl/sql , it does not recognise the syntax
```