Home » Developer & Programmer » Forms » Form writing report to pdf file: problems with parameters (Forms, 10.1.2.2.0, Linux)
Form writing report to pdf file: problems with parameters [message #400522] Tue, 28 April 2009 10:02 Go to next message
dlwixon
Messages: 92
Registered: September 2008
Member
I've got a form that works in version 6.0. The form will call a report to be viewed (destype=cache) or it will call a report to be written to a pdf file on the server (destype=file&desformat=pdf&desname=/<directory>/<filename>.pdf).

The form sends parameters to the report. There are about 90 parameters (depending on options selected by the user).

In 10g, the form won't create the pdf file when it gives the report too many parameters.

When I send the report to cache, it comes up every time.

However, when I get more than 86 or 87 parameters, it won't print to a file. I have :system.message_level :=0. I don't get any error messages and I can't seem to capture what is going on. It just does nothing.

Any suggestions?
Re: Form writing report to pdf file: problems with parameters [message #400565 is a reply to message #400522] Tue, 28 April 2009 16:37 Go to previous message
dlwixon
Messages: 92
Registered: September 2008
Member
The problem here was that I had a varchar2 variable that held the entire string of report parameters. The variable wasn't big enough. I changed the size and it worked.

Previous Topic: Oracle Forms lov
Next Topic: how to create one button on tabular layout?
Goto Forum:
  


Current Time: Mon Feb 03 23:50:59 CST 2025