This content has been marked as final. Show 11 replies
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;
PLines INTEGER := 1000;
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');
FOR i IN 1 .. PLines
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
Sorry, I thought that your problem was getting it started in the first place.
It sounds like you might not have LD_LIBRARY_PATH env variable set.
Edited by: tony.g on Nov 20, 2012 4:44 PM
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
Is there a rwrun.sh ?
I seem to remember that in general we don't tend to use the rwrun executable directly.
Is it so? .. the rwrun.sh is present there in the location which i passed into the OS Command.
I need some solution & fast, .. my boss is on my head :(
Plz save my life.
I would study the Dbms_scheduler package.
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