SQL Error (-7402): collcast()
Posted in 2010
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