Oracle stored procedure - difference between 10g and 11g perhaps? -
the following stored procedure code works in our dev , test environments run oracle 11g not work in our 10g prod environment:
first, created own data structure in oracle hold array of varchar2:
create or replace type mat_multiples_array table of varchar2(100);
here procedure code:
create or replace procedure mat_submit_job (v_multiples_columns_to_add in our_schema.mat_multiples_array) v_jobno number; v_job_name varchar2(100); v_error_message varchar2(32000); begin v_job_name := 'doesnt matter right now'; dbms_scheduler.create_job(v_job_name,program_name=>'mat_job_program'); dbms_scheduler.set_job_anydata_value(v_job_name,1,sys.anydata.convertcollection(v_multiples_columns_to_add)); dbms_scheduler.enable(v_job_name); end;
again, same code works in 11g in our dev , test environments, , compiles in our 10g environment, appears barf during runtime, on second dbms_scheduler line (in bold).
does dbms_scheduler work in 10g? or perhaps there problem 'sys.anydata.convertcollection(v_multiples_columns_to_add)'
here error message:
ora-22370: incorrect usage of method originated line 19 in procedure.
line 19 line convertcollection() call.
please help!
i found in documentation:
http://docs.oracle.com/cd/b19306_01/appdev.102/b14258/d_sched.htm#i1000820
set_job_anydata_value requires owner of job or have alter privileges on job. can set job argument value if have create job privilege.
this might related well: anydata collections based on rowtype
Comments
Post a Comment