1. #1
    Ext User
    Join Date
    Sep 2007
    Location
    Cayman Islands
    Posts
    23
    Vote Rating
    0
    ollyando is on a distinguished road

      0  

    Default Best practises for using JSON and Oracle

    Best practises for using JSON and Oracle


    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

  2. #2
    Sencha - Community Support Team jay@moduscreate.com's Avatar
    Join Date
    Mar 2007
    Location
    DC Area =)
    Posts
    16,364
    Vote Rating
    81
    jay@moduscreate.com is a name known to all jay@moduscreate.com is a name known to all jay@moduscreate.com is a name known to all jay@moduscreate.com is a name known to all jay@moduscreate.com is a name known to all jay@moduscreate.com is a name known to all

      0  

    Default


    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.

  3. #3
    Ext User
    Join Date
    Feb 2008
    Posts
    39
    Vote Rating
    0
    treqx is on a distinguished road

      0  

    Default


    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

Thread Participants: 2