Change item - Need Help

From: Radosław G±siorek <szczurak_at_wp.pl>
Date: Mon, 27 Sep 2004 16:47:07 +0200
Message-ID: <cj98p8$3h4$1@achot.icm.edu.pl>

Hi to all again

I have problem with running this procedure in Oracle Portal. This procedure is comipiled correctly but when I select "execute" I have error:

      error: begin
      "PORTAL"."TEST2";
      end; (WWV-11230)

Here how it looks:

Create or Replace Procedure PORTAL.TEST2 as

     l_item_master_id number;
     p_user_name VARCHAR2(60) := 'xxx';
     p_password VARCHAR2(60) := xxx;
     p_company VARCHAR2(60) := NULL;

     masterid number;
     itemid   number;
     catid    number;
     folderid   number;
     regionid number;

exceptionLevel number := 0;
begin
wwctx_api.set_context('xxx','xxx',NULL);

for c1 in (SELECT * FROM WWSBR_ALL_ITEMS i WHERE i.ID=38280) loop

     masterid := c1.ID  ;
     itemid   := c1.MASTERID  ;
     catid    := c1.CAID  ;
     folderid := c1.FOLDER_ID  ;
     regionid := c1.FOLDER_REGION_ID  ;

   end loop;

htp.center(masterid || ' ' || itemid || ' ' || catid ||' ' ||folderid || ' ' || regionid );

l_item_master_id := wwsbr_api.modify_item (   p_item_id => 38280,

  p_master_item_id => 36395,
  p_caid => 33,
  p_folder_id => 1,
  p_display_name => 'Movie Review',
  p_region_id => '',

   p_text => 'This is the text of the review.' );

wwpro_api_invalidation.execute_cache_invalidation;

end;

Thanks for all suggestions and Helps

-- 
mgr inż.Radosław G±siorek - programmer
e-mail: rg_at_ambsoft.pl
amb software sp. z o.o., ul.Łabędzia 18, 65-501 Zielona Góra
tel.+48 68 4537040, fax +48 68 3241295
www: http://www.ambsoft.pl, e-mail: office@ambsoft.pl

Received on Mon Sep 27 2004 - 09:47:07 CDT