Hi Formspider team,

I get the following error when using api_datasource.importfromfile trying to import an XLS file:

ORA-06502: PL/SQL: numeric or value error: invalid LOB locator specified: ORA-22275 ORA-06512: at "SYS.DBMS_LOB", line 533 ORA-06512: at "FSR_SYS.BDF_DBOBJECTACCESS_MNG", line 5052 ORA-29540: class ConvertExcelToDataXML does not exist

The procedure i had used to work prior to 1.3.

Any idea what is causing this?

Thanks, Michiel A.

asked 22 Apr '13, 12:27

Michiel%20A's gravatar image

Michiel A
accept rate: 13%

Hi Michiel,

This error occurs since some java files used during XLS import are not loaded in your database. It seems like there is an error in our v1.3 installer regarding this issue, we will fix it as soon as possible.

In the meantime, you can download necessary jar and class files from the following link and load them manually: http://theformspider.com/download/poi.zip

To load:

  • Extract the downloaded "poi.zip" file into a directory of your choice (e.g. "C:\poi").
  • Execute the following command from the OS command line to load the "poi-3.2-FINAL-20081019.jar" file:
    loadjava -user [dbuser]/[password] -resolve "C:\poi\poi-3.2-FINAL-20081019.jar"
    Here, you have to use the name of the formspider schema (which is "formspider" by default) and its password as the [dbuser] and [password] values.
  • Execute the same command for the "ConvertExcelToDataXML.class" file:
    loadjava -user [dbuser]/[password] -resolve "C:\poi\ConvertExcelToDataXML.class"

Hope this helps,


answered 24 Apr '13, 06:37

Ibrahim%20Sandalli's gravatar image

Ibrahim Sand... ♦♦
accept rate: 25%

Thanks, it is working again.


(24 Apr '13, 08:21) Michiel A

This problem is fixed in version 1.3.2


(02 May '13, 10:37) Ibrahim Sand... ♦♦
Your answer
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](http://url.com/ "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: 22 Apr '13, 12:27

Seen: 2,350 times

Last updated: 02 May '13, 10:37

© Copyright Gerger 2017