Each,
Am getting this error from a form. I know what the error means am just
wanting to know what generates this error. It is not coming back from
the server as there is no referential integrity between the 2 tables on

My system is Windows XP.
Oracle 10g : 10.1.0.2.0
I can connect through sqlplus (and toad) with the following command:
sqlplus scott/tiger /

I have created a package the returns a ref cursor.  The package is as
follows:
CREATE OR REPLACE PACKAGE p_storedivreg_hist  is
 -- Author  : JEFFC

Is there a free ER-tool out there.  Basically, I want to be able to
reverse engineer a database and generate ddl changes from the model.
I looked at ERWIN and some of the other tools but they seem to be
overkill for what I need.

I have to embed some com+ (not activeX) app into form, but didn't find
the way to do it. I set up the container with single-record:true, wrote
the appropriate registered class and imported methods of ole lib. but
when I try to insert object into container the list of aviable ...

I'd like to lay out a problem we had the other day ... maybe someone
can make sense of this:
We're currently deploying our system, that includes report generation,
to a number of production plants where they can then view some Oracle

Announcing
Yellowfin
Information collaboration and reporting tool
Drag and Drop Report Builder

 Can some one recommend a good open source database Query Tool. I am
looking for the following features:
 Can connect and query against any database ( perhaps through an
interface like JDBC or OLE DB)

It seems to be such a basic requirement in reporting world but don't
know how to do this in Oracle reports 6i.
I need to suppress the duplicate values in the report output:
Current O/P                  Desired OUTPUT

I have a  problem when I execute an application on a server  response time
is very long for create  pdf file  whereas locally it's normal ...Any ideas
?

ORACLE APPLICATONS 11i TRAINING FROM US RETURNED PROFESIONALS
·      Oracle Financials 11i
·      Oracle Applications - Technical
·      Oracle Applications DBA

I am sure someone might have encountered this problem.
I have six Queries in Data Model. Based on certain parameter value, I
need to change the source field setting for each field in the report
output.

San Ramon-based Sunflower Systems (www.sunflowersystems.com) has is
hiring a seasoned Oracle Developer for our development team.  The
developer will create Oracle Forms, Reports and for Pl/SQL development.
Candidate should have 5+ years Oracle development experience and know

Please correct this SQL which is returning multiple records.
SELECT DISTINCT a.CALL_TIME, a.P_TRANSID, a.METHOD, b.CALL_STATUS, FROM
DT_IPOS_CALL_LOG a, DT_IPOS_CALL_STATS b WHERE a.P_TRANSID IN (7569302)
AND a.P_TRANSID = b.P_TRANSID (+) ORDER BY a.CALL_TIME

Is there a way to get the week number that a date falls in based on the
52 week calendar?  Is there a function or how could I obtain this?
Thanks.
Jeff