lob_033.phpt 948 B

12345678910111213141516171819202122232425262728293031323334353637383940414243
  1. --TEST--
  2. various oci_lob_write() error messages
  3. --EXTENSIONS--
  4. oci8
  5. --SKIPIF--
  6. <?php
  7. $target_dbs = array('oracledb' => true, 'timesten' => false); // test runs on these DBs
  8. require(__DIR__.'/skipif.inc');
  9. ?>
  10. --FILE--
  11. <?php
  12. require __DIR__.'/connect.inc';
  13. require __DIR__.'/create_table.inc';
  14. $ora_sql = "INSERT INTO
  15. ".$schema.$table_name." (id, blob)
  16. VALUES (2, empty_blob())
  17. RETURNING
  18. blob
  19. INTO :v_blob ";
  20. $statement = oci_parse($c,$ora_sql);
  21. $blob = oci_new_descriptor($c,OCI_D_LOB);
  22. $blob->save("");
  23. oci_bind_by_name($statement,":v_blob", $blob,-1,OCI_B_BLOB);
  24. oci_execute($statement, OCI_DEFAULT);
  25. var_dump($blob->save(""));
  26. var_dump($blob->save("data", 100));
  27. require __DIR__.'/drop_table.inc';
  28. echo "Done\n";
  29. ?>
  30. --EXPECTF--
  31. Warning: OCILob::save(): OCI_INVALID_HANDLE in %s on line %d
  32. bool(true)
  33. bool(true)
  34. Done