All,
   I'm curious why I'm getting a reparse for every execution in the
following scenario (this is a simplified example of a real problem):
SQL> select * from dual;

I have a package like this
CREATE OR REPLACE PACKAGE PAY_CN_VIEWS_PKG AS
TYPE payment_methods_record IS RECORD(
assignment_action_id

Suggestions appreciated on how to tackle parallel application
processing on a single large Oracle table.
The PL/SQL application processes needs to grab n rows for update,
process, update and commit them. Several of these application processes

I want to pass a list of proc names along with their arguments to a
parent proc. The parent proc then needs to dynamically call the procs
one-by-one passing in the params for each proc, and then return REF
CURSORs back to the caller (in this case the data access layer of the

I have a rman backup set of datafiles, controlfiles and archivelog
files. Backup set of archivelog files was made 2 days after backupset
of datafiles and controlfiles. I`m able to restore controlfiles and
datafiles after disaster situation but i do not know how to restore

I have to develop a job for transforming a hierarchy of users of the
form:
USER
--------------

I need to retrieve a 17 digit number stored in the Oracle table.
I tried using the int64 to retrieve the number. However, the Pro C
interpret the int64 as 32bit int. Is there anyway that I can work around
this?

I have five partitions on four external hardrives that have no
RAID,(one partition on each hardrive) and i want to use ASM on those
partitions. I want to know  if i can recover my data incase one
hardrive fails.

using oracle 9i on win 2000 - my anti-virus software is Panda 2005 security
The AV seems be causing a problem - trying to open a connection to the db
using toad & the listener service generates errors (which of course you
can't see anywhere!) & stops the service (sent 27 emails to ...

I want oracle 10g to start when i reboot my redhat enterprise linux
box.
I changed the two fields in my /etc/oratab file to Y but this did not
do the job. Is there  extra steps that i need to do.

Basically, I've simplified down what I need from a much larger problem.
I don't even know if this is possible.  What I need is to be able to
create a select that will look at a VARCHAR2 field (call it text_field)
and generate a row for every 5 characters in that column.  In other

I created a database and im trying to remove it. I ran dbca but the
delete button is disabled.
Thanks.
Moe

I am updating 10 million records. The query has to make joins with
multiple tables and it's a time consuming process. I would like to
autocommit every record as it is found by the subquery. How can i do it
?

How do I select the top 20 earners from my database?
urgent.
cheers

I am facing problem in compiling a .pc file that has a decleration
FILE* start_output_file(const char *partner, const char *type, char
*filename)
error shown is