Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- $sql = 'CALL procedures.name(1,1,'text',1,1,'2017-08-30','2017-08-31',?,?)';
- try {
- $con = new PDO("idb:all_the_connections_stuu",'user','pass',
- [
- PDO::ATTR_PERSISTENT => FALSE,
- PDO::ATTR_ERRMODE => PDO:ERRMODE_EXCEPTION,
- PDO::ATTR_CURSOR => PDO::CURSOR_SCROLL,
- PDO::ATTR_AUTOCOMMIT => 0
- ]
- );
- $stmt = $con->prepare($sql);
- $stmt->bindParam(1, $errorNumber, PDO::PARAM_INT); //also trying without PDO::params
- $stmt->bindParam(2, $errorCode, PDO::PARAM_STR, 800); //and with |PDO::PARAM_INPUT_OUTPUT
- $stmt->execute(); //return *TRUE*
- var_dump($errorNumber); //return NULL
- var_dump($errorCode); //return NULL
- var_dump($stmt->fetchAll(PDO::FETCH_ASSOC)); //returns Error
- $stmt->closeCursor();
- $stmt = null;
- } catch (PDOException $e) {
- echo ($e->getMessage());
- }
- Fatal error: Uncaught PDOException: SQLSTATE[57017]: <<Unknown error>>: -332
- [IBM][CLI Driver][DB2] SQL0332N
- Character conversion from the source code page "" to the target code page "" is not supported.
- SQLSTATE=57017
- (SQLFetchScroll[-332] at /home/user/shared/PDO_IBM-1.3.4/ibm_statement.c:1306) in /var/www/html/server/testsIBM/index.php:80
- Stack trace:
- #0 /var/www/html/server/testsIBM/index.php(80): PDOStatement->fetchAll(7, 0)
- #1 {main}
- thrown in /var/www/html/server/testsIBM/index.php on line 80
- $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