hi!..
i m tryint to get the data from the in out var of the procedutre
using the  OCI...
pls help me

I have a child parent releationship going. And I want to enforce
referential
integrity with triggers. When I update the parent table I want it to go
down

we are getting following error message on our tracle log. Please help
on this.
*** 2005-07-20 12:17:00.974
*** SESSION ID:(166.5758) 2005-07-20 12:17:00.973

My department is starting a conversion from Informix to Oracle.
I am in the process of loading the unloaded data from Informix into
our Oracle database using SQLLDR.  I have been able to load all of
our tables but one.  Here is what the table schema looks like:

When I spool select query results with SQL*Plus,
It always add query strings to the spooled file.
How to spool without query string?
I need to use the spooled file in a cron job.

I am trying to predict the growth of my database every month. Is there
any tool or method which I can use to predict the growth.
Wanted to know whether oracle database only maintains any of these
statistics in the data dictionary.

Dear Candidate,
'The Shapers' is an Executive Search & HR Solution Company based
out of Delhi/NCR. We are searching for people in IT Domain globally
(India & Abroad) and we are working with the best brands.

have to load a mass of data (some million records) on a regular basis
into Oracle 10g release 2. While I am sure that sqlldr can achieve the
needed performance for the "text" part of the data I am unsure about
how to optimally organize the binary data (pictures) that is

I am getting the following message during installation of forms 6i on
windows 2000 professional and windows XP professional and the
installation process hault.
looking forward to an advice/

I have a table with only a field
create table t
(text varchar2(100));
I put 4 rows in it

Am wanting to install Oracle 9.2.0, Developer 6i and then Patch 13 for
Developer.
Are there problems or issues which I should know about? Have installed
them in order specified above but having various problems with

I'm experiencing a weird error when using the SQL*Plus 'clear screen'
command in Oracle 10g Release 2 on Windows XP.
Issuing the command causes SQL*Plus to abort, with a nice invitation
to advise Microsoft about the problem.  I'm thinking they won't care,

Hi;
I'm working with Designer v 9.0.2 and trying to learn how to use it for
size estimation.
I have created a small 3 entity ERD. I've provided initial, max,

I'd like to supress the "Connected." message after connecting to a db.
This is because I use a script like:
spool myoutput.txt
connect scott@mydb1/tiger

hai there,
i am not able to use long data type completely in oracle 8i i am able
to use only 4000 bytes completely,is ther any configuration to be done
before using it.