Results 1 to 3 of 3

Thread: Best practises for using JSON and Oracle

  1. #1
    Ext User
    Join Date
    Sep 2007
    Location
    Cayman Islands
    Posts
    23
    Vote Rating
    0
      0  

    Default 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 User jay@moduscreate.com's Avatar
    Join Date
    Mar 2007
    Location
    DC Area =)
    Posts
    16,364
    Vote Rating
    86
      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
      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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •