We are launching First time in India latest and greatest
Oracle CRM
Vennela Technologies is a Leader in ERP Training and Projects in
India. Vennela Technologies has been in Training for the last 3 years.

there is stored procedure which has one argument of type: REF CURSOR
RETURN record in INOUT mode.
When I set the procedure as data source in Reports, I do not have to give
any arguments. I can write in form only name of package and name of

Oracle Applications 11i (11.5.10) DBA
Vennela Technologies Pvt. Ltd is a Leader in ERP Training and Projects
in India. Vennela Technologies has been in Training from past last 4
years. Vennela trained more than 2000 users in Oracle Applications

I would like to know 2 things regarding oracle.
1)Does Oracle PL/SQL now support the returning of a recordset to the
business tier by just using a single 'SELECT ColNameList FROM
tablename', or still I have to use  the cumbersome method of declaring

we are running forms 6i Patch18 on Windows2003 SP2 terminal servers and
periodaclly we get the reports background engine failures.  The event view
has this
Faulting application RWRBE60.EXE, version 3.0.0.0, faulting module

Can someone provide me with idiot proof instructions on how to do a
trace on a froms session?
My environment is:
Forms [32 Bit] Version 10.1.2.0.2 (Production)

Oracle 10g DBA on Redhat Enterprise 4.0 Linux Administration
We are Launching new batch on Oracle 10g Database administration
Vennela Technologies is a premier Education services provider in Asia
Pacific with a huge client base in India , Europe and North America .

I am trying to import an existing eclipse project into jdeveloper.
It is an 'ant build' - I was hoping to import using the xml build file
or something to that effect - NO LUCK!.
Please if anyone can help out that would be great.

Oracle 10g DBA on Redhat Enterprise 4.0 Linux Administration
We are Launching new batch on Oracle 10g Database administration
Vennela Technologies is a premier Education services provider in Asia
Pacific with a huge client base in India , Europe and North America .

Is there a way to suppress the "FRM-40654 Record has been updated by
another user" error and automatically re-query when doing a save in
forms?  I have tried trapping the error in the on-error trigger and
adding an execute_query at the end of the key-commit trigger, but so

All,
We are using a flattened table for the Reports. This table is called
as JP_HISTORY_TBL. This table is like a Data Warehouse having all the
required fields for the reports in a flattened structure. So it has

I have a large table called as JP_HISTORY_TBL. This has about 10
million rows.
I did a select * from jp_history_tbl where assigned_to_pg_new =
'IS00000025'

We're need to migrate a Forms 6i application to work w/ 10g
(and also to move into the 21st century), and are evaluating
possible alternatives. Forms 10g is of course one of them,
as is Application Express.