« Return to all random blog posts

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.

 

 

Comments:
Show comments