This content has been marked as final. Show 2 replies
That's not going to work because the job hasn't run yet when you perform the insert. So :F103_ROWS_PROCESSED wont contain anything useful.
Why don't you try performing the insert as part of the job, e.g.
l_sql := 'BEGIN update_tl_tables_1(:APP_JOB, :F103_ROWS_PROCESSED); insert into gse_lng_jobs (instance, job_id, rows_processed) values ('''||l_instance||''', '||l_job||', :F103_ROWS_PROCESSED); END;';
...something like that.
Thanks - yep that was the issue. I thought that since the insert came after the API that it would work, but I guess not. I actually just added the insert to the procedure itself and everything works now. Thanks for the help!