Home » Fusion Middleware & Colab Suite » Weblogic & Application Server » call sql through Application Server (oracle form developer 10g)
call sql through Application Server [message #522431] Fri, 09 September 2011 07:37 Go to next message
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;
Re: call sql through Application Server [message #522436 is a reply to message #522431] Fri, 09 September 2011 08:13 Go to previous messageGo to next message
joy_division
Messages: 4949
Registered: February 2005
Location: East Coast USA
Senior Member
That is because code runs on the application server and not on the client machine.

"Not working" is not an oracle error message.
Re: call sql through Application Server [message #522479 is a reply to message #522436] Sat, 10 September 2011 09:33 Go to previous message
Littlefoot
Messages: 21580
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Maybe you should check CLIENT_HOST instead?
Previous Topic: SRW.RUN_REPORT_OBJECT 10gR2 from Forms
Next Topic: WLS 10.3.3 and FMW 11.1.1.3.0 create virtual directory mapping
Goto Forum:
  


Current Time: Sun Aug 09 19:07:04 CDT 2020