Creating Oracle procedures with PHP/OCI

Spent ages trying to get this working.

The problem was the carriage return in the stored procedure sql code that was getting passed through to Oracle.

$sql = preg_replace('/r/','',$sql);

fixed the problem.