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.


asked 10 Apr '14, 08:20

grajan777's gravatar image

accept rate: 10%

What is the PL/SQL line you are executing that raises this exception?

(10 Apr '14, 16:18) Yalim ♦♦

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_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.



(11 Apr '14, 02:41) grajan777

I need the value of l_ds at the time the api_datasource.clear raises the exception.

(11 Apr '14, 03:26) Yalim ♦♦

Hi Yalim,

I replace the first showpopupmessage command with 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.



(11 Apr '14, 03:48) grajan777

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


(12 Apr '14, 07:34) Ibrahim Sand... ♦♦

Hi Ibrahim,

I have send the file with further explanation.



(12 Apr '14, 10:37) grajan777

Hi Ibrahim,

I think I have isolated the error. I will send to you separate mail on this.



(14 Apr '14, 23:13) grajan777
showing 5 of 7 show 2 more comments
Be the first one to answer this question!
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text]( "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported



Asked: 10 Apr '14, 08:20

Seen: 2,707 times

Last updated: 14 Apr '14, 23:13

© Copyright Gerger 2017