Best practises for using JSON and Oracle

[ollyando]

Hi Guys,

Just wondering if anyone has manage to get json data to and from oracle.
I've seen posts about using php to access the database, just wondered if anyone has used plsql directly to produce json for grid data, or php.

Regards

Orlando

[jay@moduscreate.com]

your method of accessing the data through PLSQL and PHP is out of context of this forum.

However, you will need to use json_encode to shuttle the data upstream.

[treqx]

Someone did write a PL/SQL package to generate JSON data:

I haven't used it personally, we use DWR with Java so I simply assign my data to a Map and read it on the Ext side with DWRProxy.

There are also java classes available from json.org that you can use in combination with JDBC.

Cheers,
Michel