Toad World® Forums

Toad Script only in TDP 4.1?


#1

I inherited a project written using “Toad Script” to only define the variables. I am unfamiliar with this. It runs fine in Toad Data Point 4.1 but immediately throws errors in Toad for Oracle 12.6 and Toad Script Runner as soon as it hits the first --TOAD = . e.g., --TOAD: SET VARIABLE = 10, etc. Surely I should be able to run this in another Toad app. Those other apps don’t seem to recognize the “Toad Script”. Any ideas as to what’s happening?

Thank You.


#2

I don’t know much about TDP, but Toad for Oracle’s scripts are SQL*Plus compliant, so we don’t support any proprietary syntax.

However, I am surprised that you’re getting an error in TFO if the command starts with a comment marker.

In any event, you can do this in Toad with DEFINE (same as SQL*Plus).

For example:

define var_blah = 'blah blah';

begin
  dbms_output.put_line('&var_blah');
end;
/

#3

Toad scripts is only supported by the Toad .net products. (Toad data Point, Toad for SQL Server, Toad for Db2, Toad for SAP)