Translating with DrWatson… this can take a few seconds the first time.
This is a genuine, complex translation. DrWatson protects commands, error codes, and log output while naturally translating the surrounding text. It’s translated once and saved.
Informix V10
System HP true 64
When the stored procedure is executed using Informix user - it runs fine.
When stored procedure is executed using a application user with execute on the
collcast function - It gets -7402
Looking for answers on how to resolve this issue
The error code states
-7402 Internal error.
If this error occurs, note all circumstances and contact Technical Support at
tsmail@us.ibm.com.
Has anyone experienced and resolved this issue without opening a issue with
IBM?
Informix user
2/9/10 11:47 AM Executing statement:
execute function sls_get_prod_ids(list{'AWINMM'}, 'ZASYST068');Query Executed; Results shown in Output1; Exec Time: 00:00:00.093; Rows
retrieved: 1
Application user
2/9/10 11:57 AM Executing statement:
execute function sls_get_prod_ids(list{'AWINMM'}, 'ZASYST068');SQL Error (-7402): collcast(): collcast: arg invalid func desc
Error Position: Ln: 1 Col: 1
Thank you,
Christine
We use strictly necessary cookies to make this site work. With your
consent we’d also use optional cookies for analytics and marketing. You can accept all,
reject all, or choose. Read our Cookie Policy.