Databases
cancel
Showing results for 
Search instead for 
Did you mean: 

Compilation error in Forms 3.0

Bejoy C Alias
Respected Contributor

Compilation error in Forms 3.0

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

Be Always Joy ......
3 REPLIES
Indira Aramandla
Honored Contributor

Re: Compilation error in Forms 3.0

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
Never give up, Keep Trying
Eric Antunes
Honored Contributor

Re: Compilation error in Forms 3.0

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
Each and every day is a good day to learn.
Yogeeraj_1
Honored Contributor

Re: Compilation error in Forms 3.0

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
No person was ever honoured for what he received. Honour has been the reward for what he gave (clavin coolidge)