Home » Developer & Programmer » Forms » Calling SQLPLUS Code help
Calling SQLPLUS Code help [message #80184] Tue, 20 August 2002 13:07 Go to next message
Tyler
Messages: 123
Registered: January 2002
Senior Member
Hello,

I have this code, it's calling sqlplus fine and finding the pwd,username, and connect string fine, but then when I tack on the last part (P:...) to execute that file when opened, SQLPLUS sorta' flashes like it opened and then it closes... suggestions?

declare
v_string varchar2(100);

begin

host('PLUS80W.EXE '||:user_name||'/'||:pwd||'@'||:connect_string||' '||'P:tpdpPRODUCE_PUBL_EXT.sql');

end;

Report message to a moderator

Re: Calling SQLPLUS Code help [message #80185 is a reply to message #80184] Tue, 20 August 2002 21:45 Go to previous message
Subhash
Messages: 105
Registered: October 2001
Senior Member
Try
host('PLUS80W.EXE '||:user_name||'/'||:pwd||'@'||:connect_string||' @'||'P:tpdpPRODUCE_PUBL_EXT.sql');

Report message to a moderator

Previous Topic: How to connect Form builder to Oracle
Next Topic: how can we restrict user so that he can close the running form by
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Tue Apr 16 18:31:27 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.