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 Comment

Yes, send me an email when a new comment is posted.

The avatars shown next to comments are Gravatars. Click here to get a Gravatar account for free and any other site that supports it will show your avatar too!