Toad World® Forums

what Toad setting is there to turn SET DEFINE OFF for F9


#1

One of the people in our department has her Toad setup such that when she does
an F9 of

BEGIN

Dbms_output.put_line ( ‘abc & def’ );

END;

It does not ask for value for &DEF. If you execute via F5 it does. This is fine.
I would just like to find which setting causes F9 ignore & signs.


#2

Does she have SET DEFINE OFF in her login/glogin scripts?


#3

Right click in the editor, ‘Prompt for Substitution Variables’

I got a syntax error when trying that with your block though, so maybe
there’s another problem/question around the corner.


#4

Outlook quotes cause the syntax error.


#5

The syntax error is probably because outlook put in smart apostrophes.


#6

No. I checked for that.