fusio icon indicating copy to clipboard operation
fusio copied to clipboard

OCI_NO_AUTO_COMMIT

Open halloigi opened this issue 3 years ago • 1 comments

hi..i tried with this code in action..but, i got { "success": false, "message": "An error occurred at the worker: Undefined constant 'OCI_NO_AUTO_COMMIT'" }

connection to oracle was ok.but why i got this response?? my docker was successful build with this issue, https://github.com/apioo/fusio-docker/pull/16

and here my code action

`<?php

use Fusio\Worker\Connector; use Fusio\Worker\Dispatcher; use Fusio\Worker\Generated\Context; use Fusio\Worker\Generated\Request; use Fusio\Worker\Logger; use Fusio\Worker\ResponseBuilder;

return function(Request $request, Context $context, Connector $connector, ResponseBuilder $response, Dispatcher $dispatcher, Logger $logger){ $connection = $connector->getConnection('oraclecon');

$result = `$connection->fetchAllAssociative("somequery");`
return $response->build(200, [],[
	'message' => 'test',
	'result' => $result
]);

}; ` thank you

halloigi avatar Jul 06 '22 17:07 halloigi

Hi, ok so it looks like the PHP oracle extension is not correctly loaded, could you check through a phpinfo whether the oracle php extension is loaded?

chriskapp avatar Jul 06 '22 21:07 chriskapp