# executeStoredProcedure Don't work

**URL:** <https://forum.servoy.com/t/executestoredprocedure-dont-work/8347>\
**Category:** Classic Servoy\
**Created:** [November 1, 2007, 8:33pm UTC](https://forum.servoy.com/t/executestoredprocedure-dont-work/8347 "2007-11-01T20:33:36Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![Armin\_kessler](https://avatars.discourse-cdn.com/v4/letter/a/45deac/32.png) [@Armin\_kessler](https://forum.servoy.com/u/Armin_kessler)\
**Post date:** [November 1, 2007, 8:33pm UTC](https://forum.servoy.com/t/executestoredprocedure-dont-work/8347/1 "2007-11-01T20:33:36Z")

</div>

If someone have experience with executeStoredProcedure with SQL Anywhere 9.02.

I use call to stored procedure in my application with VisualFoxPro.

I am new in Servoy and I trying to run a method that use executeStoredProcedure to insert a record in the database.

In the attached file is the code of the method and stored procedure.

The method execute and don’t display error but do not insert the record.

Thanks Armin Kessler

[The Code.doc](https://forum.servoy.com/uploads/short-url/gkocBVwQmRq0uruei7wl623SrzN.doc) (21.5 KB)

---

<div class="post-metadata">

**Author:** ![rgansevles](https://avatars.discourse-cdn.com/v4/letter/r/3d9bf3/32.png) [@rgansevles](https://forum.servoy.com/u/rgansevles)\
**Post date:** [November 2, 2007, 8:00am UTC](https://forum.servoy.com/t/executestoredprocedure-dont-work/8347/2 "2007-11-02T08:00:27Z")

</div>

Armin,

Your test for the exception is wrong.

```auto
if ( ! plugins.rawSQL.getException() == null )

```

should be

```auto
if ( ! (plugins.rawSQL.getException() == null) )

```

or

```auto
if ( plugins.rawSQL.getException() != null )

```

Rob