URGENT:Problem on a function call from a Form

hello,

3 years ago we buyed an integrated system with oracle 7, the designers declared a function on the database, and this function its used on many forms, now, we need to do some changes to the form, but when we are generating the form from the source code (*.inp file) we have an error indicating that the function is not declared.

when i try to generate the form i get this error:

-------cut here --------

FRM-30137: Compile Error on procedure CHECK_MANDATORY_FIELDS. PL/SQL error 201 at line 13, column 22:

   identifier 'SF_FRMT_DT' must be declared    Item ignored
-------cut here------------

here the identifier "SF_FRMT_DT" its a function that return a DATE value, this function its declared on the database like:

• cut here ---- dev> describe SF_FRMT_DT FUNCTION SF_FRMT_DT RETURNS DATE Argument Name Type In/Out Default?
  • ----------------------- ------ -------- PASSED_DATE DATE IN
    ------- cut here ----------
    

What can i do for solve this problem?

Thanks in advanced for your help

Regards
Alejandro Galindo

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Tue Jun 22 1999 - 13:52:08 CDT