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.
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 ...
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.