Home » Developer & Programmer » Forms » Forms 6i Crashes when Omitt Optional Parameters (Forms, DB 10G, Windows Server 2003)
icon5.gif  Forms 6i Crashes when Omitt Optional Parameters [message #572826] Tue, 18 December 2012 00:58 Go to next message
Messages: 168
Registered: May 2008
Location: Fsd, Pakistan
Senior Member

I have created a simple function in database that take 2 arguments, the last one is optional.

Now i call the function in Forms 6i PL/SQL Trigger and omitt the default (optional) parameter the form builder crashes when i compile the form (CTRL + SHIFT + K)

i have tried to used both words "DEFAULT" and ":=" in the function's signature for making an optional argument.
Re: Forms 6i Crashes when Omitt Optional Parameters [message #572847 is a reply to message #572826] Tue, 18 December 2012 02:45 Go to previous message
Messages: 21151
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Try to create an overloaded function - one would accept only one parameter, while another one would accept both of them. From a form, call the one that is appropriate in that context.
Previous Topic: how can calc net sal of month end
Next Topic: best way to pass 100+ parameter in form A to form B
Goto Forum:

Current Time: Thu Aug 24 00:11:36 CDT 2017

Total time taken to generate the page: 0.01533 seconds