I have a table as
table1
ID INTEGER
NAME VARCHAR2(50)

I have one query related to subject, we did some trials, please let me
know if my interpretatios are wrong.
Using Ref cursor in Oracle 10.1.0.2
CREATE OR REPLACE PACKAGE PkgTestRefPatient AS

Platform: Oracle 9.2.0.7 on AIX 5.3
Developer presented me with this:
I am trying to use the RETURNING... INTO... clause on an Oracle insert
statement but am getting the following error:

Oracle 9.2.0.5 on AIX 5L
DB is NoArchive log mode.
I have a corrupt datafile.
The database will not open. I was hoping to offline the file and open

Our  P and A department has raised a query about one of their reports
They use windows SQLPLUS ( Release 9.2.0.1.0 ) to execute the query.
The report uses the day number (1 - 7).
When we run the report in Windoze, it returns a different value to when we

Platform: Oracle 10.2 EE on Win2003 server
We have a requirement to physically relocate two databases involved in
a master/materialized view replication environment.  An additional
requirement will be to add transparent data encryption to selected

Gentlemen,
I have an OCI-based code making all the Oracle calls for the main
application. All that stuff works, except in one specific environment.
In this case, the app freezes on the first call to

(9.2.0.6, linux)
I'm in a situation where oracle spatial doesn't use a domain index even if I use the index hint.
In fact, as long as the spatial operator (sdo_relate) is the only predicate in the where
clause, the index gets used, so the index is okay.

I have a problem installing Oracle Designer 10g, during the process of
the installation I get an error saying that the file tnsus.msb on the
path: C:\oracle\product\10.2.0\db_2\NETWORK\mesg cannot be accessed
because it is being used by another process. I tried to ignore the

Hi Faculties,
   When i create a tablespace in Oracle 8.1.7, i get an when i include
'Segment Space management Auto' clause. Is this feature not supported
in Oracle 8.1.7?

Hello all.  I'm writing to this group in hopes of a way to fix my
problem.  So far, no one has been able to fix this issue, they all keep
telling me to "deal with it, that is the way it is."  I just won't
accept that oracle could be this crummy.

In Oracle RDBMS 10.2 it is practically impossible to invalidate a PL/SQL
object. I tried with adding indexes, dropping primary key and analyzing
the underlying tables, but the PL/SQL procedure build on top of the table
remained valid. Oracle 9i PL/SQL objects were much more ...

I have two ways of setting session variables in SQL+, one is using
var(iable) and the other is using define. Can anyone tell me if they
have had any luck in setting such variables from an application? I am
using Borland compilers and ADO with Oracle 9.2 and 10g. I have been

I have a client who has two disparate disk arrays that can't talk to each
other.
I'd like to have a shared Oracle home using a clustered filesystem, but, to
my knowledge, I cannot find a compatible clustered filesystem that offers

my id kuldeepchitrakar@gmail.com