Perl and Oracle

This page (http://www.orafaq.com/wiki/Perl) shows all the basics of setting up a perl script connection to an Oracle database can making basic calls...

PHP Oracle FAQ - Oracle Wiki

PHP Oracle FAQ - Oracle Wiki

A very good page showing how to work with PHP and Oracle.

I stumbled onto this page as I was just looking for a sample/simple stored procedure to borrow:

create procedure proc1(p1 IN number, p2 OUT number) as

begin

p2 := p1 + 10;

end;

|MG| Win7codecs 2.6.9 Download

|MG| Win7codecs 2.6.9 Download

There is something mysterious about codecs ... this one comes highly recommended :)

ORACLE-BASE - Recompiling Invalid Schema Objects

ORACLE-BASE - Recompiling Invalid Schema Objects

this is a good background summary page... the commands I like to keep at my fingertips are:

spool pre-compile-errors.lst

col owner form a15

col object_name a60

set line 100

select OWNER, object_name, object_type, status from dba_objects where status <> 'VALID';

spool utlrp.lst

@?/rdbms/admin/utlrp

spool post-compile-errors.lst

col owner form a15

col object_name form a30

set line 100

select OWNER, object_name, object_type, status from dba_objects where status <> 'VALID';

expdp/impdp, remap_schema and Oracle Wiki

Data Pump Export (expdp) and Data Pump Import(impdp) - Oracle Wiki

The Oracle wiki is great - a clear and concise repository of examples of standard DBA commands... I have been using remap_schema with impdp today. This wasn't on the page but all the basics of expdp and impdp were.