How Can I Connect Flutter (dart) With My Oracle Server ? Have Some One Tried On This?

I need to Connect My Flutter App With my Oracle Server ..Searched Google but no good resource found except one on dart web but it is no more used with current dart version.Have Som

Solution 1:

I have a similar use case scenario, I'm creating a new mobile app in Flutter for an already existing web app that use an Oracle DB.

As the above replies I've create the REST APIs using this Oracle Database driver for Node.js node-oracledbhttps://github.com/oracle/node-oracledb. So far I can say that it is stable and well documented. You can also add this one https://www.npmjs.com/package/simple-oracledb in order to extend capabilities of oracledb (I've use this one to run multiple oracle operations in a single transaction).

After that on Flutter you can create your models using json_serializablehttps://pub.dartlang.org/packages/json_serializable to generate to/from JSON code for a class. You can parse the response that came from the API in order to convert the JSON response to object (or even better a dataset output send in json response to a list of objects) .

https://medium.com/flutter-io/some-options-for-deserializing-json-with-flutter-7481325a4450

Solution 2:

As @Raouf Rahiche commented above my suggested solution would also be to go for REST APIs solution that is make your Database schema on oracle and do some server side code to connect with the database and send or retrieve data in the form of JSON Its being used as most widely solution now a days for server-client communication.

But if you still want your app to communicate directly with oracle, i found a useful library on Dart package site. Oracle 0.1.0

Hope this will help you

Solution 3:

Creating RESTful web service is the solution. Oracle has provided ORDS(Oracle Restful Data Service) to create web service using PL-SQL. No need to do server side coding in any other language. ORDS can be configured with command line or GUI in Oracle's SQL Developer. Minimum Database version should be 12C R 2 as it gives good support to JSON table. I have implemented all four handles in ORDS[get,put,post and delete] and connected with flutter app.