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: 21042
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: Arabic Support in Forms & Report 10g
Next Topic: how can calc net sal of month end
Goto Forum:

Current Time: Tue Mar 28 09:00:29 CDT 2017

Total time taken to generate the page: 0.07955 seconds