Toad World® Forums

Oracle RDB Driver connection and using variables


#1

I’m currently working out of Toad Data Point 3.2 and have made a connection to a Oracle RDB Driver through ODBC connection within the Toad product. I am trying to “declare” a variable (see example below) but keep receiving an error. My issue is I’m trying to write a query to pull a set of data by limiting on a “where” clause, the data type of the field is a date field.

Example of my quick test code that is receiving an error (remember I’m connected to a ODBC connection to a Oracle RDB Driver):

declare @dt_timeframe date

the above gives me a syntax error, any guidance helps. Thanks.


#2

in oracle, plsql syntax is:

declare

dt_timeframe date;

begin

some code…

end;

/