call sql through Application Server [message #522431] |
Fri, 09 September 2011 07:37 |
TAHIRJADI
Messages: 16 Registered: September 2010 Location: KARACHI
|
Junior Member |
|
|
given blew procedure successfully working on form 6i but is not working application server.kindly help me.
thanks
declare
str varchar2(500);
pstr varchar2(30);
dat date;
mext varchar2(50);
name varchar2(12);
mfname varchar2(111);
begin
pstr:= 'abc/admin@db';
message('RETAIL Spooling In Process!!');
mfname := 'AGENT_DATA'||'.txt';
:MSG := 'Making spool file C:\'||mfname;
synchronize;
str:='PLUS80W '||pstr||' @Q:\SQL\AGENT_DATA.sql '||mfname||' '||TO_CHAR(:REPDATEF,'DD/MM/YYYY')||' '||TO_CHAR(:REPDATET,'DD/MM/YYYY');
host(str);
:MSG := 'Process Completed!...';
pause;
end;
|
|
|
|
|