Skip to Main Content

Oracle Database Discussions

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!

Error on Job/Scheduler "ORA-03115 unsupported network datatype or representation"

Kam__apexSep 11 2020 — edited Sep 11 2020

Dear Friends

I am working on Oracle 10g Database. I created a procedure to insert the data in the table calling through a job but its not working. When i check the property/view of job through PL/SQL Developer. it gives the below error.

“ORA-03115: unsupported network datatype or representation”

My procedure is

create or replace procedure testjob is

begin

  insert into test

  (emp_id,emp_name)

  values

  (1,'kkk');

  commit;

end testjob;

and job is as below

BEGIN

   dbms_scheduler.create_job (

    job_name => 'MYJOB',

    job_type => 'PLSQL_BLOCK',

    job_action => 'TESTJOB;',

    start_date => '10/sep/2020 9.15.00AM',

    enabled => true,

    repeat_interval => 'FREQ=DAILY;INTERVAL=1'

   );

END;

Please help.

Regards

Kam

This post has been answered by Mustafa KALAYCI on Sep 11 2020
Jump to Answer
Comments
Post Details
Added on Sep 11 2020
1 comment
598 views