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'
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
I do have encountered these errors many times and finally found a solution and the reason behind it through your post. I tried to manipulate so many things to remove this error but everything failed. Thanks for suggesting this nice solution.
ReplyDeletesap software training
Natalia. Happy that it helped you..
ReplyDeleteHello,
ReplyDeleteI am new to oracle.. I would like to ask what do you mean by this..
"In your shell simply execute
FORMS60_PATH=$FORMS60_PATH:$AU_TOP/forms/US:$AU_TOP/resource"
How is this done?
Thank you.
Hi Blue,
DeleteSorry for the late reply. If you are still facing the problem :
I meant type the following in your command line and press enter
FORMS60_PATH=$FORMS60_PATH:$AU_TOP/forms/US:$AU_TOP/resource
I wish to show thanks to you just for bailing me out of this particular trouble.As a result of checking through the net and meeting techniques that were not productive, I thought my life was done"Devops Training in Bangalore".
ReplyDelete