Skip to Main Content
Forums

Español

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 PDF

User_B1RVPJul 1 2022

image.pngBuenas, podrían ayudarme con este dilema? el sistema que desarrollamos en apex imprime varios informes en pdf, salvo en este caso que nos sale este error al momento de cargar el pdf. cual podria ser el problema en este caso? siendo que en otras paginas de la app si funciona. Les agradecería su ayuda. Desde ya gracias

Comments

ORASCN

Hi ,
Use the SQLEXEC feature to execute database statements or call procs from GG processes. Please check the below,

SQLEXEC (0 Bytes)17 Customizing Oracle GoldenGate Processing (0 Bytes)
Regards,
Veera

Kremnican

Unfortunately SQLEXEC in the MAP statement executes even before the MAP is "executed" (insert / update / delete) as the result can be used in the MAP statement itself.
Standalone SQLEXEC has a timer, which means it either runs when not needed or there's no guarantee it will be run right before the COMMIT, e.g. the timing may cause to run the SQL procedure some time after COMMIT, which may cause inconsistent behaviour.

LexmanLexman-Oracle

As your requirement is ti run the SP on a subset of data, you must use sqlexec with MAP statement. Sqlexec for MAP statements have the option to run the SP on the data set before or after the mapping
Check options AFTERFILTER/BEFOREFILTER in sqlexec documentation
Also , you can choose the iteration of SP run , again option EXEC {MAP | ONCE | TRANSACTION | SOURCEROW}
https://docs.oracle.com/en/middleware/goldengate/core/19.1/reference/sqlexec.html#GUID-34A0589B-1450-4BC9-A573-683895AAA1EC

1 - 3

Post Details

Added on Jul 1 2022
#español-discusiones
2 comments
67 views