How to print sql statement after bind using oci8

[mistrhanky]

I am doing a simple query but would like to log my insert/update statements. However, I cannot figure out how to print the complete sql statement when using bind values. Can anyone help?

function test() {
    $sql = "select name from activity where id = :id";
    $stid = oci_parse($db, $sql);
    $pid = 468;
    oci_bind_by_name($stid, ":id", $pid);
    oci_execute($stid);
}

I want to print $sql after the bind so I will have the complete query string.

[Atli]

Hey.

I doubt this is possible. The query is handled outside the scope of the PHP script. There would have to be a OCI8 function that provided this functionality, and none of the once listed in the manual seem to do that.