entity api generator error
I'm attempting to use the API Toolkit for Banner 7 APIs to create an API for a local table. I was able to create the dml package for the table but when I try to run gurmkpk_api.sql it does not generate a complete spec and body. The last line in the output file is:
Exception in p_gen_api:-6502:ORA-06502: PL/SQL: numeric or value error
If I comment out the exception line in entity_api_generator.p_gen_api and run gurmkpk_api.sql again the errors are:
DECLARE
*
ERROR at line 1:
ORA-06502: PL/SQL: numeric or value error
ORA-06512: at "ROBERSOT.ENTITY_API_GENERATOR", line 587
ORA-06512: at "ROBERSOT.ENTITY_API_GENERATOR", line 1611
ORA-06512: at "ROBERSOT.ENTITY_API_GENERATOR", line 2414
ORA-06512: at "ROBERSOT.ENTITY_API_GENERATOR", line 3169
ORA-06512: at line 3
Has anyone ran into this issue while generating entity APIs and if so what did you do to get around it? Thanks!
I'm sorry you haven't gotten
I'm sorry you haven't gotten a response to this yet. A week or so ago I upgraded the API Generator to the latest version here but I didn't have time to test it at the time. I read your post and quickly went and generated an API just in case however I did not receive the error you did.
I don't know how helpful this is, but make sure that you have the latest version of the Entity_API_Generator package compiled into your database and also that you are using the corresponding version of the scripts that go a long with it (such as gurmkpk_api.sql etc.). That's all I did and it seems to work fine.
Anyway I hope you may have already figured out your problem or you get a better suggestion than this one ;-)