Skip to Main Content

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

JSON error in package

73pixieGirlDec 22 2010 — edited Jan 26 2011
I'm trying to incorporate an ExtJS tree into my Apex app and the example I'm following creates a JSON-Object. When I try to compile the Specification the first error I get says "Identifier 'JSON' must be declared". I thought I needed the json.js file so I included that in my app but still no luck. Does anyone know what the problem might be? Here is my Package Specification:
11	create or replace package PCK_EXTJS_JSON_EXAMPLE is
12	 
13	  -- Author  : AHILDEBRANDT
14	  -- Created : 10.08.2009
15	 
16	  -- Purpose : check if category has sub-categories
17	  function hasChildren(i_cat_id in number) return boolean;
18	 
19	  -- Purpose : create JSON-Object for category;
20	  --           recursive
21	  function getJsonObject(i_cat_id in number default 0) return json;
22	 
23	  -- Purpose : function that calls getJsonObject and returns the result as string
24	  function getTreeDataDynamic return varchar2;
25	 
26	end PCK_EXTJS_JSON_EXAMPLE;
Thank you,
Tammy
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 23 2011
Added on Dec 22 2010
23 comments
1,790 views