ORA-06502: PL/SQL: numeric or value error: character to number conversion error

From: Vaughan Mc Carthy <vmccarthy_at_worldaccess.com>
Date: 12 May 2003 08:48:49 -0700
Message-ID: <7db8e886.0305120748.28c75b8a_at_posting.google.com>

Hi

I have the following piece of code, which results in the following error when trying to execute it:
ERROR at line 1:
ORA-06502: PL/SQL: numeric or value error: character to number conversion error
ORA-06512: at "WADBA.GRANT_PROC", line 17 ORA-06512: at line 1

Code:
create or replace PROCEDURE grant_proc AS

own VARCHAR2(30);        
nam VARCHAR2(30);        
v_cur INTEGER;
v_cur1 INTEGER;        
cursor pkgs is          
select ora_dict_obj_owner, ora_dict_obj_name from wadba.event_table;
BEGIN      
open pkgs;      
loop        
fetch pkgs into own, nam;        
exit when pkgs%notfound;        


--v_cur := dbms_sql.open_cursor;        

--dbms_sql.parse(v_cur,'grant SELECT, INSERT, UPDATE, DELETE on
'||own||
--'.'||nam|| ' to developer', dbms_sql.native);
v_cur := sys.dbms_sys_sql.open_cursor(); sys.dbms_sys_sql.parse_as_user(v_cur,'grant SELECT, INSERT, UPDATE, DELETE on '||own||

'.'||nam|| ' to developer', dbms_sql.native,'SYSADM');        
sys.dbms_sys_sql.close_cursor(v_cur);        
v_cur1 := dbms_sql.open_cursor;        
dbms_sql.parse(v_cur1,'create synonym developer.'||nam||' for '||own||
'.'||nam, dbms_sql.native);        
dbms_sql.close_cursor(v_cur1);        
commit;        
delete from wadba.event_table;        
commit;      
end loop;      

end;
/

Thanks
Vaughan Received on Mon May 12 2003 - 17:48:49 CEST