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.