On Mon, 7 May 2001, Sterling Hughes wrote:
> sterling Sun May 6 18:35:02 2001 EDT
>
> Modified files:
> /phpdoc/en/functions oci8.xml
> Log:
> Fix OCINewDescriptor() example
>
>
> Index: phpdoc/en/functions/oci8.xml
> diff -u phpdoc/en/functions/oci8.xml:1.19 phpdoc/en/functions/oci8.xml:1.20
> --- phpdoc/en/functions/oci8.xml:1.19 Sat May 5 21:42:23 2001
> +++ phpdoc/en/functions/oci8.xml Sun May 6 18:35:01 2001
> @@ -260,7 +260,13 @@
> records just after the insert.
> */
>
> -$conn = OCILogon("scott","tiger");
> +$conne {
> + // $lob_upload contains the temporary filename of the uploaded file
> + $conn = OCILogon($user, $password);
> + $lob = OCINewDescriptor($conn, OCI_D_LOB);
> + $stmt = OCIParse($conn,"insert into $table (id, the_blob)
> + values(my_seq.NEXTVAL, EMPTY_B
> += OCILogon("scott","tiger");
>
HUH??
HOw'd this get in there :)
changing that ;)
_Sterling
> $stmt = OCIParse($conn,"insert into emp (empno, ename) ".
> "values (:empno,:ename) ".
> @@ -769,7 +775,7 @@
> $stmt = OCIParse($conn,"insert into $table (id, the_blob)
> values(my_seq.NEXTVAL, EMPTY_BLOB()) returning the_blob into
>:the_blob");
> OCIBindByName($stmt, ':the_blob', &$lob, -1, OCI_B_BLOB);
> - OCIExecute($stmt);
> + OCIExecute($stmt, OCI_DEFAULT);
> if($lob->savefile($lob_upload)){
> OCICommit($conn);
> echo "Blob successfully uploaded\n";
>
>
>
>