PDF report oto print(with trigger) in PLSQL side

Hello @savasciftci 

In general, please copy the code directly in order for anybody to easily read-through and give feedback.

However, I just skimmed through your screenshot, and clearly saw that you’ve not created a new Archive instance (Archive_API.New_Instance), which will surely fail the Print Job creation (Print_job_api.Print) because there’s no related Print job contents (Print_Job_Contents_API.New_Instance) created.

A successful report print should first create a new Print Job object, and an archive instance, and a job content in order to execute the print. 

I’d suggest you to follow the below flow to get the job done.

1. Create the print job object (with printer ID via the report attr object) and get the print job ID
2. Create the archive instance (with report ID, archive parameters, etc by feeding report attr and the parameter attr) which returns the new archive ID (result key)
3. Then, create the print job content (feed the job ID [step 1] and result key [step-2] via attr) 
4. Print (by providing the job ID)

This should get you the successful report print (with related archive and print manager records).

Hope this helps.

/Manulak