How to use TQuery with Oracle SQL syntax for variable assignments and Params?

Question

In a regular Query on Oracle SQL we could use:

var_user VARCHAR2(256) := 'eduard'
select * from a_table where user_name = var_user

If I use this code in Delphi's TQuery.SQL.Text I get the error Incorrect Token Followed By ":"..

I believe it is happening because Delphi uses : symbol in this case to specify a parameter inside TQuery.SQL.Text to be replaced by the values set at TQuery.Params[].

What I really want to do is SomeVarInsideSQL := :MyParam and I can't because of that error. What should I do? (delphi-xe3-zeoslib)

I belive you post incomplete code in your question. because one thing is assing a value to a string, other is create a sql command. — Juan Carlos Oropeza, Nov 06 '15 at 14:42
The value will be used in a SQL command, but it is not relevant which command it is, in the question. — NaN, Nov 06 '15 at 14:51
maybe this help http://stackoverflow.com/questions/16924629/parameters-in-sql-delphi-7 — Juan Carlos Oropeza, Nov 06 '15 at 14:59
The example on the question link you gave works with Access, which do not have `:` in it's syntax and then it does not interfere with `Params[]`. The problem in Oracle SQL is on the `:=` tokens. — NaN, Nov 06 '15 at 15:35

kobik · Accepted Answer · 2015-11-06T17:48:26.633

2

You need to escape : to :: if you have to bypass specific TQuery Parameter parsing.

edited Nov 06 '15 at 17:48

answered Nov 06 '15 at 17:13

kobik

21,001
4
61
121

How to use TQuery with Oracle SQL syntax for variable assignments and Params?

1 Answers1