Compilation error in Forms 3.0

[Bejoy C Alias]

We have some data base procedures in Oralce 7.1.4/HP-UX 10.20
But when used in forms 3.0, while compiling it gives error as
PL/SQL error 313 at line 18, column 1:
For eg:-
'F_CAL_FIN_YEAR' not declared in this scope
Statement ignored

[Indira Aramandla]

Hi Bejoy,

Error "PL/SQL 313: 'name' not declared in this scope"

You receive this error when you attempt to compile a Form trigger or PL/SQL program unit that calls database stored procedures or functions. You can successfully execute the database stored subprogram from SQL*Plus.

The reason is there is no declaration for the given identifier within the scope of reference. The identifier might be misspelled, its declaration might be faulty, or the declaration might be placed incorrectly in the block structure. It could also be that you tried to reference an undefined type. Either you failed to declare the type identifier or it is not within the scope of the reference.

Check your spelling and declaration of the identifier. Also confirm that the declaration is placed correctly in the block structure.

Indira A

[Eric Antunes]

Hi Bejoy,

Is this F_CAL_FIN_YEAR valid? Is the user from which you compile the form as access granted to it: try to executing it with this user...

Is it part of a package you must invoke it using the package name before, like this, for example:

select .F_CAL_FIN_YEAR from dual;

Best Regards,

Eric Antunes

[Yogeeraj_1]

hi bejoy,

as mentioned above by Indira, this error may be becase there is no declaration for the given identifier within the scope of reference. The identifier might be misspelled, its declaration might be faulty, or the declaration might be placed incorrectly in the block structure.

You should check your spelling and declaration of the identifier. Also confirm that the declaration is placed correctly in the block structure.

hope this helps!

kind regards
yogeeraj