Want to call target procedure using dynamic SQL.
Target procedure is defined thus:
create or replace package vr is
procedure form_1

Oracle 10.2.0.1.0 on Win2k3
Poking around on this one, having never laid my eyes on 10.x before
last week.  This was a 'shook it out of the box, all defaults'
installation.  With a little work I was able to figure out how to get

I would like to find an application which allows me to read data from a
database (object-relational database schema), display it visually, make
it editable and offer me the opportunity to write changed data to the
database.

i'm quite a newbie in Pro*C.
I have a Pro*C program that calls a stored procedure.
I would like to trace to debug my stored procedure (already tested in
SQLPLUS) in that pro*c context.

I'm evaluating 10g ASM under AIX 5.2. Drop partitioned table drops the
table but some ghost partitions remain. Is it an ASM bug ? Someone have
experienced this ?

I am trying to find the key which is used to partition the tables given
by following statement.
Select table_name ,PARTITIONING_TYPE      from all_part_tables;
Is there any SQL statement which can help in this case??

Is there any service in oracle to join the remote table realtime( each table
located in the different DB and different network)?
Location A has information about the customer information, Location B has
information about the purchase info( number of

Db : Oracle 9.2.0.7 standard edition
I recently tried to set sql trace session for a session, and had an
issue with trace file not being big enough.
Steps that I performed are:

I am facing a very weired problem in performance. The particular query
is running on and on .... I think I should try Full Scan on tables
Particularly Voucher Tables and Join should be Hash Join rather than
nested. Any help would be greatly appreciated.

I have a table with about 180,000 rows and 50 columns, and another
table which has an identical structure but is empty.  The source table
has no indexes or constraints; the destination table has a primary key
that is a combination of varchar2 and number columns.

SQLPlus newbie here. I found many references on how not to print
compute label by using a noprint column. All fine and good, but how
about I want to see that label, even if the column I`m using is really
one I want with a noprint option?

Case: A new HP DL585 server dedicated to Oracle database use. Equipped
with two AMD dual core processors (upgradeable to four CPUs if CPU
becomes the bottleneck). Initially 16 gigabytes of RAM, more RAM will be
added if required. Red Hat Linux 4 AS. Four internal 15k 146 GB U320

Am in the midst of trying to relocate 2 databases involved in a
replication environment.  In the new location, the master site is
running Ora 8.1.7.4 EE on Solaris 9.  (Yes, yes, I know! )  The MV site
is running 10.2 on Win2k3.

I thought I had this all sorted out.....
Created a type:
create type vc2000_array as table of varchar2(2000)
/

Hey, all.
I'm working through configuring a standby database under 8.1.7.4 for
reporting purposes.
It works, which is nice. I'm now just working through various scenarios