emilydickinson
New Member
Curious as to whether or not you can prepare a statement, bind it, and then preview the generated SQL as followed (the oci_preview_sql function is a place holder):\[code\]// Glorious declaration of a non-specific query$statment = oci_parse($handle, "SELECT x FROM y WHERE variable = :value");// Bind up some variablesoci_bind_by_name($statement, ':value', $value);...// Location of interestoci_preview_sql($statement); // ? is there some method like this? // Execute itoci_execute($statement, OCI_DEFAULT);\[/code\]