Using Oracle on Solaris

[Dale Strickland-Clark]

I need to write a tiny little program which makes use of an Oracle database
on Solaris. Just a single SQL statement. Nice and simple.

Coming from a Windows/SQLServer/ADO background, I'm having a bit of trouble
finding some of the basics.

Given that I already have Oracle and Python installed on the Solaris box,
what else do I need?

A little code snippet would be very handy.

Thanks.

[Bernard Delmée]

> Given that I already have Oracle and Python installed on the Solaris box,

what else do I need?

You'll need a C compiler (Sun's or gcc), and the cx_Oracle module.
Grab the source code at http://www.computronix.com/utilities.shtml
When building the module (see the included instructions), make sure
you've got a working oracle environment (eg 'sqlplus' can be invoked,
and the oracle libraries can be found by the linker...)

The Python Database API is documented at:
http://www.python.org/peps/pep-0249.html

Cheers,

Bernard.

[Dale Strickland-Clak]

Bernard Delmée :

You'll need a C compiler (Sun's or gcc), and the cx_Oracle module.
Grab the source code at http://www.computronix.com/utilities.shtml
When building the module (see the included instructions), make sure
you've got a working oracle environment (eg 'sqlplus' can be invoked,
and the oracle libraries can be found by the linker...)

The Python Database API is documented at:
http://www.python.org/peps/pep-0249.html

Cheers,

Bernard.

Excellent. Thanks very much.
--
Dale Strickland-Clark
Riverhall Systems Ltd, www.riverhall.co.uk