google analytics

meta

adsense

Showing posts with label f60gen. Show all posts
Showing posts with label f60gen. Show all posts

Friday, July 8, 2011

Forms Error : bad bind variable 'PARAMETER.G_QUERY_FIND'

When compiling a form the following error may be encountered :


Compiling KEY-NXTBLK trigger on XXXXXXX data block...
Compilation error on KEY-NXTBLK trigger on XXXXXXX  data block:
PL/SQL ERROR 49 at line 1, column 1
bad bind variable 'parameter.G_query_find'
PL/SQL ERROR 49 at line 1, column 1
bad bind variable 'parameter.G_query_find'
PL/SQL ERROR 49 at line 3, column 1
bad bind variable 'parameter.G_query_find'

Compiling WHEN-NEW-BLOCK-INSTANCE trigger on XXXXXXX data block...
Compilation error on WHEN-NEW-BLOCK-INSTANCE trigger on XXXXXXX data block:
PL/SQL ERROR 49 at line 3, column 2
bad bind variable 'parameter.G_query_find'
PL/SQL ERROR 49 at line 3, column 2
bad bind variable 'parameter.G_query_find'
PL/SQL ERROR 49 at line 5, column 2
bad bind variable 'parameter.G_query_find'
.
.
.
.
Compilation errors have occurred.


Form not created

**********************

Cause : FORMS60_PATH not properly set or incorrect

Solution: Set FORMS60_PATH=$FORMS60_PATH:$AU_TOP/forms/US:$AU_TOP/resource

In your shell simply execute

FORMS60_PATH=$FORMS60_PATH:$AU_TOP/forms/US:$AU_TOP/resource

This should solve the problem

LinkWithin

Related Posts Plugin for WordPress, Blogger...