Skip to Main Content

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Get_Block Error when installing an application

Elena.mtcFeb 27 2013 — edited Mar 4 2013
Hi all,

I tried to recover a backup I had made some days ago, and I got the following error when installing the application:

Error GET_BLOCK Error.
ORA-20001: GET_STMT error. ORA-20001: Execution of the statement was unsuccessful. ORA-06550: line 34, column 68: PLS-00103: Encountered the symbol "&" when expecting one of the following: ) , * & = - + < / > at in is mod remainder not rem <an exponent (**)> <> or != or ~= >= <= <> and or like like2 like4 likec between || multiset member submultiset <pre> <br>begin <


I looked in the .sql application and searched for the """ or even for the symbols &" and I found nothing. I checked the character set and it seems right, the application is in UNICODE-UTF8 and the database is in UTF8 as well. I'm working with APEX version 4.1.1 and apex listener 1.1.

Has anyone got this error before, or does anyone have a tip on where to investigate?

Thanks in advance.
Elena.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 1 2013
Added on Feb 27 2013
2 comments
286 views