PL/SQL (MOSC)

MOSC Banner

No idea what is going on....database trigger, runs pl/sql, that submits a concurrent program...unpre

edited May 3, 2012 1:32AM in PL/SQL (MOSC) 1 commentAnswered
For phase I, Oracle consulting wrote this process for us to print labels.   the process was to:

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.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center