Exception ORA-06502 occurs with api_datasource.clear command

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.

 api_application.showpopupmessage($$plsql_unit || '.enterqry 10:' || '.ds.' || l_ds);
  api_datasource.clear(l_ds);
  api_application.showpopupmessage($$plsql_unit || '.enterqry 20:' || '.ds.' || l_ds);

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:

FS_QRY.enterqry 10:.ds.CM_SEG

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 the api_datasource.clear API raises the exception?

Regards,
Ibrahim