Hi Community,
I want to trigger PDF report print job from Oracle side. I try to write one procedure but it doesn’t work. Could you help me Please ?
Thank you
Userlevel 4
+8
Hello
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.
- Create the print job object (with printer ID via the report attr object) and get the print job ID
- 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)
- Then, create the print job content (feed the job ID [step 1] and result key [step-2] via attr)
- 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
Reply
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.