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!

http://apex.oracle.com/pls/apex/ : Ajax call error ORA-01950

BirtheJan 6 2012 — edited Jan 7 2012
Good afternoon,
I have requested an official Oracle Apex workspace in order to have a look into 4.1. I made a small application with some dynamic action calls. I created a plsql call save some values in a table.
declare
  l_flag      smallint; 
  l_res_id    number := :P1_RESSOURCE;
  l_res_valid number := :P1_RES_VALID;
 
begin
  -- Ressourcen Name speichern wenn notwenig
  begin
    select 1 into l_flag 
    from oo_ressource 
    where nvl2(:P1_RESSOURCE,or_id,0) = nvl(:P1_RESSOURCE,0) 
      and nvl2(:P1_RESSOURCE,or_name,'') != :P1_RES_NAME 
      and length(:P1_RES_NAME)> 0;
    
    update oo_ressource set
      or_name = :P1_RES_NAME
    where or_id = l_res_id;
    
    if SQL%NOTFOUND then
      select tupel_seq.nextval into l_res_id from dual;
      insert into oo_ressource(or_id, or_name)
      values(l_res_id, :P1_RES_NAME);
    end if;
    commit;
  exception when others then
    null;
  end;

  --Zeitraum speichern
  update oo_res_valid set
    orv_from = :P1_RES_FROM,
    orv_to   = :P1_RES_TO
  where orv_id = l_res_valid;
  if SQL%NOTFOUND then
    select tupel_seq.nextval into l_res_valid from dual;
    insert into oo_res_valid(orv_id, orv_or_id, orv_from, orv_to)
    values(l_res_valid, l_res_id, :P1_RES_FROM, :P1_RES_TO);
  end if;
  commit;
    
  :P1_RESSOURCE := l_res_id;
  :P1_RES_VALID := l_res_valid; 
  
end;
If I click on the save button which executes the ajax call I receive the following error messages:
AJAX-Aufruf gab Serverfehler ORA-01950: keine Berechtigungen für Tablespace 'USERS' für PL/SQL-Code ausführen zurück.

Ajax call ORA-01950: no priviledge on tablespace USERS for PL/SQL code.

What kind of setting can I made to solve the problem ?

Many thanks.

brgds,
Birthe
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 4 2012
Added on Jan 6 2012
1 comment
186 views