Dear all, I am getting the following error on execution of api_datasource.clear command: ORA-06502: PL/SQL: numeric or value error: character string buffer too small. Kindly suggest me a solution or an alternative. What is required is to clear my datasource without actually deleting the data. With Regards. George.
showing 5 of 7
show 2 more comments
|
What is the PL/SQL line you are executing that raises this exception?
Hi Yalim,
Following is the code which raises this error. showpopupmessage are used as debugging code to find out the exact statement which raises the error. l_ds stands for datasource. The error appears before the second showpopupmessage statement.
The problem with this error is that it does not occur at every execution of the statement. It comes sometimes only.
Regards,
George.
I need the value of l_ds at the time the api_datasource.clear raises the exception.
Hi Yalim,
I replace the first showpopupmessage command with api_alert.show so that I can copy the message and following is the message content. The value of l_ds is CM_SEG. This is a valid datasource and that's why this works somethimes:
After this, in the next statement api_datasource.clear(l_ds) the error message appears and then the next showpopupmessage command is executed.
Regards,
George.
Hi George,
The problem is probably related with the data contained in this datasource. Since the data may dynamically change during runtime (via datasource execution or inserts, updates..), the problem occurs sometimes (for a specific data) and sometimes not. Can you e-mail the insert scripts of the data contained in this datasource to
contact@theformspider.com
when theapi_datasource.clear
API raises the exception?Regards,
Ibrahim
Hi Ibrahim,
I have send the file with further explanation.
Regards.
George.
Hi Ibrahim,
I think I have isolated the error. I will send to you separate mail on this.
Regards.
George.