No idea what is going on....database trigger, runs pl/sql, that submits a concurrent program...unpre
trigger on material transactions table
call pl/sql program A to write a record to a staging table, print flags of No
concurrent program (pl/SQL that runs every minute to read all records from the stageing with a print flag of No, generate flat file (multiple records), ftp to windows server, run through Symtrax software and print labels
We are currently live with this process, but it's slow due to the timer of the scheduled concurrent request and the subsequent ftp process.