Advertisement
Guest User

Untitled

a guest
Sep 1st, 2017
93
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.59 KB | None | 0 0
  1. $sql = 'CALL procedures.name(1,1,'text',1,1,'2017-08-30','2017-08-31',?,?)';
  2. try {
  3. $con = new PDO("idb:all_the_connections_stuu",'user','pass',
  4. [
  5. PDO::ATTR_PERSISTENT => FALSE,
  6. PDO::ATTR_ERRMODE => PDO:ERRMODE_EXCEPTION,
  7. PDO::ATTR_CURSOR => PDO::CURSOR_SCROLL,
  8. PDO::ATTR_AUTOCOMMIT => 0
  9. ]
  10. );
  11. $stmt = $con->prepare($sql);
  12. $stmt->bindParam(1, $errorNumber, PDO::PARAM_INT); //also trying without PDO::params
  13. $stmt->bindParam(2, $errorCode, PDO::PARAM_STR, 800); //and with |PDO::PARAM_INPUT_OUTPUT
  14. $stmt->execute(); //return *TRUE*
  15. var_dump($errorNumber); //return NULL
  16. var_dump($errorCode); //return NULL
  17. var_dump($stmt->fetchAll(PDO::FETCH_ASSOC)); //returns Error
  18. $stmt->closeCursor();
  19. $stmt = null;
  20. } catch (PDOException $e) {
  21. echo ($e->getMessage());
  22. }
  23.  
  24. Fatal error: Uncaught PDOException: SQLSTATE[57017]: <<Unknown error>>: -332
  25. [IBM][CLI Driver][DB2] SQL0332N
  26. Character conversion from the source code page "" to the target code page "" is not supported.
  27. SQLSTATE=57017
  28. (SQLFetchScroll[-332] at /home/user/shared/PDO_IBM-1.3.4/ibm_statement.c:1306) in /var/www/html/server/testsIBM/index.php:80
  29. Stack trace:
  30. #0 /var/www/html/server/testsIBM/index.php(80): PDOStatement->fetchAll(7, 0)
  31. #1 {main}
  32. thrown in /var/www/html/server/testsIBM/index.php on line 80
  33.  
  34. $con = db2_connect("DATABASE=DB2D;HOSTNAME=10.243.13.65;PORT=5000;PROTOCOL=TCPIP;USERNAME=asdf23;PASSWORD=asdfasf1","", "")
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement