I need to transfer data on daily basis from an oracle 10g database
running on Linux to the sql Server 2000 database.For that I need first
to get my query output from oracle into flat file and then bulkinsert
that file into sqlserver 2000.

I've spent far too long trying to discover the answer to this very
simple question.  How do I use TOAD to display the result set from a
stored procedure?  In Microsoft SQL Server, this is effortless.  You
don't have to jump through any hoops or do anything funny!  In TOAD for

Hi I have recently installed Oracle10g. But when I try to login to the
system, I get a message that "Io exception: The Network Adapter could
not establish the connection". Can any body suggest a remedy? I am not
able to connect to the database. It is also saying the database is not

Is there anybody know how can one populate the list item with
attributes of table itself.
suppose a table Tbl_Emp has attributes like ID,Name,age ....So now I
want those attrubutes get populated in the list item.is there any

I posted this question on OTN SQLJ/JDBC forum already. But, in
circumstances of some urgency, I am taking the liberty of cross posting
here. Please excuse.
A question for OracleOCIConnectionPool gurus.

I have a attachment file in a blob field insert via a application. Can I
feetch the attachment file using sql? or another tool?
Thanks

I would like to get some advise. We have Java application server
(Tomcat) that periodically (approximately every other day) experiences
Java-level deadlocks in JDBC code.  We have full thread dumps. Please
look into the snapshot thread dump (below).

We're upgrading from Forms 6i to 9i and could do with some advice.
Our developers use Windows to develop but our direction is very much
Red Hat Linux.
Is it feasible (in the real world, not Oracle's world) to:

Please i need help about sending parameter list from form to any report. If
I try with add parameter command, i don't get results. Help for form builder
and report builder is very poor.
Thank you.

I use 9 Schemas names sgsmain1 to sgsmain9.All the Database schemas has
same oracle procedure.If i change a procedure in one schema i have to
explicitly compile to all other schemas.is there any component that
gets the schemas and compile to to all.

Below is the scenario I want to perform to test the Failover for our DR
testing:
1. Run an RMAN hot backup of the Primary Database (165)
  Include the Standby Controlfile in the RMAN backup.

I am relatively new to databsae triggers and I am currently having a
problem with an UPDATE AFTER trigger.  I am using Forms 6i to perform a
few calculations and then commit then to the database.  When these
records have been updated in the database (AFTER UPDATE) i want to

If you type hel in that SQLplus,
he rtesponds that must look at
ORACLE documentation...
(This is realy funny)...

Is there any posibility(maybe in future) to work wit graphics with
object PL/SQL like Java,(to draw lines and circles,elipses, etc...)
If is posible can you tell me where I can found some matirial about it..!!
Thanks in advance, Rubyn..!!!

I've only recently started using OID, and so far just for names
resolution to replace Onames, so my knowledge on its full capabilities
is limited. I was thinking about the possibilities of using it for an
email address repository of sorts, since Outlook supposedly has native