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.

Leave a Reply

Your email address will not be published. Required fields are marked *