igallacher
Programmer
Problem is using host command under win Xp or Nt
Under win 98 host command is called and system waits until
complete before returning control to next line in PL/SQL.
Under XP/NT,control appears to be returned to next line immediately after host command initiated. Thus,using host command to call say sqlplus to create a .lst file with the .next line in pl/sql wanting to access the .lst file.
Under xp/nt the .lst may not yet have been created or has
been locked out. Works fine under 95/98/me. MY work around is to issue a Pause command after the host command if the operating system is XP/NT. Not a neat solution but appears to work so far. Has anybody has this problem and got/know of a better solution ?
Thanks for you attention
Ian
Under win 98 host command is called and system waits until
complete before returning control to next line in PL/SQL.
Under XP/NT,control appears to be returned to next line immediately after host command initiated. Thus,using host command to call say sqlplus to create a .lst file with the .next line in pl/sql wanting to access the .lst file.
Under xp/nt the .lst may not yet have been created or has
been locked out. Works fine under 95/98/me. MY work around is to issue a Pause command after the host command if the operating system is XP/NT. Not a neat solution but appears to work so far. Has anybody has this problem and got/know of a better solution ?
Thanks for you attention
Ian