Generated parameters by the DOA

[Ralf]

Hi,

While generating an Oracle package it came to our notice that the parameters in the generated procedure and function do not get generated with the default value specified in the Oracle procedure.

The code responsible for this has been disabled in the source code, with a comment that further testing was needed.

Have the necessary tests been performed, so we can activate that piece of the code again or is there an other solution to pass along the default values?

 

[Marco Kalter]

The default values are not interpreted by the package wizard. The PL/SQL default values cannot easily be translated to Pascal default values.

 

[Ralf]

Are there any examples of default values that do not work correctly? We assume it was not the strings and integers that made the translation difficult.

 

[Marco Kalter]

Default values that include Oracle functions such as sysdate, trunc, to_char, to_date, and so on.