Re: Pl/SQL problem in Oracle Financials

I do not know if you are into evaluating 3rd party tools, but there is a product out there called AppWorx that could help. and help automate what you are trying to do. They have an interface to Oracle applications and specifically concurrent manager. They have a GUI development language that allows your to create complex dependenices between jobs and also automate many of the online jobs that require alot of user intevention. They have a way of setting dynamic variables for those online reports. That way rather than having many users requesting reports and cluttering up the system and it's resources, the users submit's the jobs normally and AppWorx schedules that whenever you tell it to run. This also does not leave your terminal or PC hanging nor does it leave you with thousands of jobs in a queue waiting to run.

Definitely looking into this product. It changed our lives and created a lights out situation for 3rd shift. They will make a believer of you too.

http://www.appworx.com

In article <3506BBDA.84B75730_at_entergy.com>,   Gillian Murugappan <gmuruga_at_entergy.com> wrote:
>
> I want to automatically fire a script from Concurrent Manager whenever
> there is a lock.
> I am writing the following procedure but it is not compiling and bombing
> out at the line
> 'from v$session'. I already granted select on v$session to oraap.
>
> I am new at PL/SQL - please help. See code below:
>
> CREATE OR REPLACE PROCEDURE oraap.track_lock_holders
> IS
> DECLARE
> user_id varchar2(15);
> BEGIN
> (select osuser into user_id
> from v$session
> where audsid=userenv('sessionid'));
>
> drop table oraap.lock_holders;
>
> create table oraap.LOCK_HOLDERS /* temporary table */
> (
> waiting_session number,
> holding_session number,
> lock_type varchar2(17),
> mode_held varchar2(10),
> mode_requested varchar2(10),
> lock_id1 varchar2(10),
> lock_id2 varchar2(10),
> user_id varchar2(15)) /* Gets it value from OSUSER */
> TABLESPACE entergy_tbl;
> END;
>
> Thanks
> Gillian
> zmkj04_at_hotmail.com
>
>

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/ Now offering spam-free web-based newsreading Received on Wed Mar 11 1998 - 00:00:00 CST