Thanks for the reply.
I've studied the Event-driven publishing through database triggers.
But wasn't able to achieve what was desired. Is it possible for u to provide me a li'l bit more detailing about how to use event-driven publishing.
Some working examples would be great.
Please reply ASAP,
Thanks for the reply. :)
The topics included in the thread were all related to the structure and script of the java source and the publishing, which is not the one making a problem for me.
What the problem is, is the pl/sql call and the command passed.
The java source is compiled successfully, the publishing of java source is successfully compiled. But when i do the pl/sql calling section by the following script: SET ServerOutput ON; DECLARE POutput Dbms_Output.Chararr; PLines INTEGER := 1000; BEGIN Dbms_Output.Enable(1000000); Dbms_Java.Set_Output(1000000); Amrit_Developers_Toolkit.ExecuteCmd(p_command => '/d02/clone-appl/apps/tech_st/10.1.2/bin/rwrun report=/d02/clone-appl/apps/apps_st/appl/gl/12.0.0/reports/US/AMRIT_BS_TFRM.rdf userid=apps/apps desformat=pdf destype=file desname=/d02/clone-appl/apps/apps_st/appl/gl/12.0.0/reports/US/AMRIT_BS_TFRM.pdf PERIOD_NAME=''APR-11-12'' P_ACCESS_SET_ID=1000 P_ORG_ID=82 P_UNIT=11'); Dbms_Output.Get_Lines(POutput,PLines); FOR i IN 1 .. PLines Loop Dbms_Output.Put_Line(POutput(i)); END Loop; END;
It gives me an output: Process err :/d02/clone-appl/apps/tech_st/10.1.2/bin/rwrun: error while loading shared libraries: libjvm.so: cannot open shared object file: No such file or directory
This is what i'm not able to resort. Plz help me guyz ...
Edited by: ac4991 on Nov 20, 2012 5:11 AM
Edited by: ac4991 on Nov 20, 2012 5:12 AM
Thanks for the reply. :)
I heard this from lot of people, but i need a li'l more detailing in it.
I mean, yepp i need to some define environment variable or may be adding a path to a certain existing environment variable. The point is, which variable and what path.
Few current environment variables defined are:
Environment Type: *"tools_home"*
Environment Type: *"web_home"*
Location of libjvm.so: +/d02/clone-appl/apps/tech_st/10.1.2/jdk/jre/lib/i386/client+
I guess this much info may be sufficient. So, if u can offer me something to make this working, please share !!
Thanks once again :D
http://docs.oracle.com/cd/E11882_01/appdev.112/e16760/d_sched.htm#i1010013 and maybe this one http://myoraclerants.blogspot.se/2010/04/executing-linux-shell-script-through.html
Edited by: Lars Sjöström on Nov 25, 2012 11:48 PM