How to use TextPad to write prompt in SQL

[Dave Wu]

Hi,

I have difficulty using the prompt command in Oracle SQL plus in
TextPad. The same command worked in the direct SQL prompt does not work in TextPad. Do you have any idea why?

define parm1=&1
select * from vicki_path where vp_uid = &&parm1
/



Thanks


Dave

[Roy Beatty]

What was the error?