Hi Team,
Coukd you please let me know why and when this below error occour's.
I have used s select statement to fetch the data as below where this function uses maily two tables code.. codelist.
Below is the sample data of above two tables
CODE TABLE
CODELIST TABLE
Now my requirement was to give description in place of client_code
Below function is the one which gives the data based on the code_id passed.
select customer_id,cc_desc(8,'D',sex) from mstr where customer_id = 'xxxx'
8 -> ocde_id
D ->Default Value
3rd paramter sex -> is a column in mstr table which which gives description of code_id .
The function cc_desc uses mainly code,code list table and get's data of description based on the code_id.The function is absolutely working fine when checked with other cleints.
Now when i ran the above sql statement for my client it is showing the below error.
Please help me what exactly the error means.
error:
ORA-12801: error signaled in parallel query server P129, instance db.insight.com:p2ka (1)
ORA-01722: invalid number
12801. 00000 - "error signaled in parallel query server %s"
*Cause: A parallel query server reached an exception condition.
*Action: Check the following error message for the cause, and consult
your error manual for the appropriate action.
*Comment: This error can be turned off with event 10397, in which
case the server's actual error is signaled instead.