alsohi24
commented
3 years ago I tried this but it didn't work either.
And I don't know if using temporary tables is a good idea. But it would be interesting to know the reason for the problem.
Open alsohi24 opened 3 years ago
alsohi24
commented
3 years ago I tried this but it didn't work either.
And I don't know if using temporary tables is a good idea. But it would be interesting to know the reason for the problem.
Hello everyone. I'm trying to call an stored procedure but apparently it doesn't work when i use cursor inside.
DreamFactory Instance
Server
{"statusCode":500,"body":"{\\"error\\":{\\"code\\":500,\\"context\\":null,\\"message\\":\\"Failed to call database stored procedure.\\\\nPackets out of order. Expected 1 received 12. Packet size=75\\",\\"trace\\":[\\"0 /home/ubuntu/dreamfactory-2.14.1-13/apps/dreamfactory/htdocs/vendor/dreamfactory/df-sqldb/src/Resources/StoredProcedure.php(258): DreamFactory\\\\\\\\Core\\\\\\\\SqlDb\\\\\\\\Resources\\\\\\\\StoredProcedure->callProcedure()\\",\\"1 [internal function]: DreamFactory\\\\\\\\Core\\\\\\\\SqlDb\\\\\\\\Resources\\\\\\\\StoredProcedure->handlePOST()\\",\\"2 /home/ubuntu/dreamfactory-2.14.1-13/apps/dreamfactory/htdocs/vendor/dreamfactory/df-core/src/Components/RestHandler.php(335): call_user_func(Array)\\",\\"3 /home/ubuntu/dreamfactory-2.14.1-13/apps/dreamfactory/htdocs/vendor/dreamfactory/df-core/src/Components/RestHandler.php(197): DreamFactory\\\\\\\\Core\\\\\\\\Components\\\\\\\\RestHandler->processRequest()\\",\\"4 /home/ubuntu/dreamfactory-2.14.1-13/apps/dreamfactory/htdocs/vendor/dreamfactory/df-core/src/Components/RestHandler.php(254): DreamFactory\\\\\\\\Core\\\\\\\\Components\\\\\\\\RestHandler->handleRequest(Object(DreamFactory\\\\\\\\Core\\\\\\\\Utility\\\\\\\\ServiceRequest), 'procedure...')\\",\\"5 /home/ubuntu/dreamfactory-2.14.1-13/apps/dreamfactory/htdocs/vendor/dreamfactory/df-core/src/Components/RestHandler.php(172): DreamFactory\\\\\\\\Core\\\\\\\\Components\\\\\\\\RestHandler->handleResource(Array)\\",\\"6 /home/ubuntu/dreamfactory-2.14.1-13/apps/dreamfactory/htdocs/vendor/dreamfactory/df-core/src/Services/BaseRestService.php(146): DreamFactory\\\\\\\\Core\\\\\\\\Components\\\\\\\\RestHandler->handleRequest(Object(DreamFactory\\\\\\\\Core\\\\\\\\Utility\\\\\\\\ServiceRequest), '_proc/indicador...')\\",\\"7 /home/ubuntu/dreamfactory-2.14.1-13/apps/dreamfactory/htdocs/vendor/dreamfactory/df-core/src/Services/ServiceManager.php(496): DreamFactory\\\\\\\\Core\\\\\\\\Services\\\\\\\\BaseRestService->handleRequest(Object(DreamFactory\\\\\\\\Core\\\\\\\\Utility\\\\\\\\ServiceRequest), '_proc/indicador...')\\",\\"8 /home/ubuntu/dreamfactory-2.14.1-13/apps/dreamfactory/htdocs/vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php(221): DreamFactory\\\\\\\\Core\\\\\\\\Services\\\\\\\\ServiceManager->handleServiceRequest(Object(DreamFactory\\\\\\\\Core\\\\\\\\Utility\\\\\\\\ServiceRequest), 'mydb', '_proc/indicador...', false)\\",\\"9 /home/ubuntu/dreamfactory-2.14.1-13/apps/dreamfactory/htdocs/vendor/dreamfactory/df-core/src/Http/Controllers/RestController.php(159): Illuminate\\\\\\\\Support\\\\\\\\Facades\\\\\\\\Facade::__callStatic('handleServiceRe...', Array)\\",\\"10 /home/ubuntu/dreamfactory-2.14.1-13/apps/dreamfactory/htdocs/vendor/dreamfactory/df-core/src/Http/Controllers/RestController.php(118): DreamFactory\\\\\\\\Core\\\\\\\\Http\\\\\\\\Controllers\\\\\\\\RestController->handleServiceRequest(Object(DreamFactory\\\\\\\\Core\\\\\\\\Utility\\\\\\\\ServiceRequest), 'mydb', '_proc/indicador...')\\",\\"11 [internal function]: DreamFactory\\\\\\\\Core\\\\\\\\Http\\\\\\\\Controllers\\\\\\\\RestController->handleVersionedService('v2', 'mydb', '_proc/indicador...')\\",\\"12 /home/ubuntu/dreamfactory-2.14.1-13/apps/dreamfactory/htdocs/vendor/laravel/framework/src/Illuminate/Routing/Controller.php(54): call_user_func_array(Array, Array)\\",\\"13 /home/ubuntu/dreamfactory-2.14.1-13/apps/dreamfactory/htdocs/vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php(45): Illuminate\\\\\\\\Routing\\\\\\\\Controller->callAction('handleVersioned...', Array)\\",\\"14 /home/ubuntu/dreamfactory-2.14.1-13/apps/dreamfactory/htdocs/vendor/laravel/framework/src/Illuminate/Routing/Route.php(212): Illuminate\\\\\\\\Routing\\\\\\\\ControllerDispatcher->dispatch(Object(Illuminate\\\\\\\\Routing\\\\\\\\Route), Object(DreamFactory\\\\\\\\Core\\\\\\\\Http\\\\\\\\Controllers\\\\\\\\RestController), 'handleVersioned...')\\",\\"15 /home/ubuntu/dreamfactory-2.14.1-13/apps/dreamfactory/htdocs/vendor/laravel/framework/src/Illuminate/Routing/Route.php(169): Illuminate\\\\\\\\Routing\\\\\\\\Route->runController()\\",\\"16 /home/ubuntu/dreamfactory-2.14.1-13/apps/dreamfactory/htdocs/vendor/laravel/framework/src/Illuminate/Routing/Router.php(658): Illuminate\\\\\\\\Routing\\\\\\\\Route->run()\\",\\"17 /home/ubuntu/dreamfactory-2.14.1-13/apps/dreamfactory/htdocs/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(30): Illuminate\\\\\\\\Routing\\\\\\\\Router->Illuminate\\\\\\\\Routing\\\\\\\\{closure}(Object(Illuminate\\\\\\\\Http\\\\\\\\Request))\\",\\"18 /home/ubuntu/dreamfactory-2.14.1-13/apps/dreamfactory/htdocs/vendor/dreamfactory/df-core/src/Http/Middleware/AccessCheck.php(62): Illuminate\\\\\\\\Routing\\\\\\\\Pipeline->Illuminate\\\\\\\\Routing\\\\\\\\{closure}(Object(Illuminate\\\\\\\\Http\\\\\\\\Request))\\",\\"19 /home/ubuntu/dreamfactory-2.14.1-13/apps/dreamfactory/htdocs/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(149): DreamFactory\\\\\\\\Core\\\\\\\\Http\\\\\\\\Middleware\\\\\\\\AccessCheck->handle(Object(Illuminate\\\\\\\\Http\\\\\\\\Request), Object(Closure))\\",\\"20 /home/ubuntu/dreamfactory-2.14.1-13/apps/dreamfactory/htdocs/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\\\\\\\\Pipeline\\\\\\\\Pipeline->Illuminate\\\\\\\\Pipeline\\\\\\\\{closure}(Object(Illuminate\\\\\\\\Http\\\\\\\\Request))\\",\\"21 /home/ubuntu/dreamfactory-2.14.1-13/apps/dreamfactory/htdocs/vendor/dreamfactory/df-core/src/Http/Middleware/AuthCheck.php(232): Illuminate\\\\\\\\Routing\\\\\\\\Pipeline->Illuminate\\\\\\\\Routing\\\\\\\\{closure}(Object(Illuminate\\\\\\\\Http\\\\\\\\Request))\\",\\"22 /home/ubuntu/dreamfactory-2.14.1-13/apps/dreamfactory/htdocs/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(149): DreamFactory\\\\\\\\Core\\\\\\\\Http\\\\\\\\Middleware\\\\\\\\AuthCheck->handle(Object(Illuminate\\\\\\\\Http\\\\\\\\Request), Object(Closure))\\",\\"23 /home/ubuntu/dreamfactory-2.14.1-13/apps/dreamfactory/htdocs/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\\\\\\\\Pipeline\\\\\\\\Pipeline->Illuminate\\\\\\\\Pipeline\\\\\\\\{closure}(Object(Illuminate\\\\\\\\Http\\\\\\\\Request))\\",\\"24 /home/ubuntu/dreamfactory-2.14.1-13/apps/dreamfactory/htdocs/vendor/dreamfactory/df-core/src/Http/Middleware/VerbOverrides.php(42): Illuminate\\\\\\\\Routing\\\\\\\\Pipeline->Illuminate\\\\\\\\Routing\\\\\\\\{closure}(Object(Illuminate\\\\\\\\Http\\\\\\\\Request))\\",\\"25 /home/ubuntu/dreamfactory-2.14.1-13/apps/dreamfactory/htdocs/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(149): DreamFactory\\\\\\\\Core\\\\\\\\Http\\\\\\\\Middleware\\\\\\\\VerbOverrides->handle(Object(Illuminate\\\\\\\\Http\\\\\\\\Request), Object(Closure))\\",\\"26 /home/ubuntu/dreamfactory-2.14.1-13/apps/dreamfactory/htdocs/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\\\\\\\\Pipeline\\\\\\\\Pipeline->Illuminate\\\\\\\\Pipeline\\\\\\\\{closure}(Object(Illuminate\\\\\\\\Http\\\\\\\\Request))\\",\\"27 /home/ubuntu/dreamfactory-2.14.1-13/apps/dreamfactory/htdocs/vendor/barryvdh/laravel-cors/src/HandleCors.php(37): Illuminate\\\\\\\\Routing\\\\\\\\Pipeline->Illuminate\\\\\\\\Routing\\\\\\\\{closure}(Object(Illuminate\\\\\\\\Http\\\\\\\\Request))\\",\\"28 /home/ubuntu/dreamfactory-2.14.1-13/apps/dreamfactory/htdocs/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(149): Barryvdh\\\\\\\\Cors\\\\\\\\HandleCors->handle(Object(Illuminate\\\\\\\\Http\\\\\\\\Request), Object(Closure))\\",\\"29 /home/ubuntu/dreamfactory-2.14.1-13/apps/dreamfactory/htdocs/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\\\\\\\\Pipeline\\\\\\\\Pipeline->Illuminate\\\\\\\\Pipeline\\\\\\\\{closure}(Object(Illuminate\\\\\\\\Http\\\\\\\\Request))\\",\\"30 /home/ubuntu/dreamfactory-2.14.1-13/apps/dreamfactory/htdocs/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(102): Illuminate\\\\\\\\Routing\\\\\\\\Pipeline->Illuminate\\\\\\\\Routing\\\\\\\\{closure}(Object(Illuminate\\\\\\\\Http\\\\\\\\Request))\\",\\"31 /home/ubuntu/dreamfactory-2.14.1-13/apps/dreamfactory/htdocs/vendor/laravel/framework/src/Illuminate/Routing/Router.php(660): Illuminate\\\\\\\\Pipeline\\\\\\\\Pipeline->then(Object(Closure))\\",\\"32 /home/ubuntu/dreamfactory-2.14.1-13/apps/dreamfactory/htdocs/vendor/laravel/framework/src/Illuminate/Routing/Router.php(635): Illuminate\\\\\\\\Routing\\\\\\\\Router->runRouteWithinStack(Object(Illuminate\\\\\\\\Routing\\\\\\\\Route), Object(Illuminate\\\\\\\\Http\\\\\\\\Request))\\",\\"33 /home/ubuntu/dreamfactory-2.14.1-13/apps/dreamfactory/htdocs/vendor/laravel/framework/src/Illuminate/Routing/Router.php(601): Illuminate\\\\\\\\Routing\\\\\\\\Router->runRoute(Object(Illuminate\\\\\\\\Http\\\\\\\\Request), Object(Illuminate\\\\\\\\Routing\\\\\\\\Route))\\",\\"34 /home/ubuntu/dreamfactory-2.14.1-13/apps/dreamfactory/htdocs/vendor/laravel/framework/src/Illuminate/Routing/Router.php(590): Illuminate\\\\\\\\Routing\\\\\\\\Router->dispatchToRoute(Object(Illuminate\\\\\\\\Http\\\\\\\\Request))\\",\\"35 /home/ubuntu/dreamfactory-2.14.1-13/apps/dreamfactory/htdocs/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(176): Illuminate\\\\\\\\Routing\\\\\\\\Router->dispatch(Object(Illuminate\\\\\\\\Http\\\\\\\\Request))\\",\\"36 /home/ubuntu/dreamfactory-2.14.1-13/apps/dreamfactory/htdocs/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(30): Illuminate\\\\\\\\Foundation\\\\\\\\Http\\\\\\\\Kernel->Illuminate\\\\\\\\Foundation\\\\\\\\Http\\\\\\\\{closure}(Object(Illuminate\\\\\\\\Http\\\\\\\\Request))\\",\\"37 /home/ubuntu/dreamfactory-2.14.1-13/apps/dreamfactory/htdocs/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/ValidatePostSize.php(27): Illuminate\\\\\\\\Routing\\\\\\\\Pipeline->Illuminate\\\\\\\\Routing\\\\\\\\{closure}(Object(Illuminate\\\\\\\\Http\\\\\\\\Request))\\",\\"38 /home/ubuntu/dreamfactory-2.14.1-13/apps/dreamfactory/htdocs/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(149): Illuminate\\\\\\\\Foundation\\\\\\\\Http\\\\\\\\Middleware\\\\\\\\ValidatePostSize->handle(Object(Illuminate\\\\\\\\Http\\\\\\\\Request), Object(Closure))\\",\\"39 /home/ubuntu/dreamfactory-2.14.1-13/apps/dreamfactory/htdocs/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\\\\\\\\Pipeline\\\\\\\\Pipeline->Illuminate\\\\\\\\Pipeline\\\\\\\\{closure}(Object(Illuminate\\\\\\\\Http\\\\\\\\Request))\\",\\"40 /home/ubuntu/dreamfactory-2.14.1-13/apps/dreamfactory/htdocs/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/CheckForMaintenanceMode.php(46): Illuminate\\\\\\\\Routing\\\\\\\\Pipeline->Illuminate\\\\\\\\Routing\\\\\\\\{closure}(Object(Illuminate\\\\\\\\Http\\\\\\\\Request))\\",\\"41 /home/ubuntu/dreamfactory-2.14.1-13/apps/dreamfactory/htdocs/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(149): Illuminate\\\\\\\\Foundation\\\\\\\\Http\\\\\\\\Middleware\\\\\\\\CheckForMaintenanceMode->handl...