# Changes to plugins.rawSQL?

**URL:** <https://forum.servoy.com/t/changes-to-plugins-rawsql/13020>\
**Category:** Classic Servoy\
**Created:** [October 11, 2010, 5:04pm UTC](https://forum.servoy.com/t/changes-to-plugins-rawsql/13020 "2010-10-11T17:04:54Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![troy](https://avatars.discourse-cdn.com/v4/letter/t/85f322/32.png) [@troy](https://forum.servoy.com/u/troy)\
**Post date:** [October 11, 2010, 5:04pm UTC](https://forum.servoy.com/t/changes-to-plugins-rawsql/13020/1 "2010-10-11T17:04:54Z")

</div>

I have a solution that is working in Servoy 5.1.4 heavily utilizing stored procedures, thanks to the rawSQL plugin. When this solution is opened in 5.2.2, strange things begin happening with the stored procedures.

The main problem is that arguments I send to the stored procedure do not get sent. It seems like one argument I send is remembered and then used for all subsequent procedure calls, even if I pass something different in. Occasionally, the value I want to send across does get sent.

Were any changes made to the rawSQL plugin that could account for this?

Here’s how I’m calling it:

```auto
var serverName = 'my_data_server'
var procedure = '{call AR_CUSTOMERINFO(?)}'
var args = [forms.customer.customer_id]
var typesArray = [0]
var maxReturnedRows = -1

var dataset = plugins.rawSQL.executeStoredProcedure(
            serverName,
            procedure,
            args,
            typesArray,
            maxReturnedRows
        )

```

---

<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:** [October 11, 2010, 8:01pm UTC](https://forum.servoy.com/t/changes-to-plugins-rawsql/13020/2 "2010-10-11T20:01:08Z")

</div>

Troy,

The only code change from 5.1 to 5.2 in the rawsql plugin is that a check has been added that the user running the sql is actually logged in.  
If not, all exec calls will return null or false.

Rob

---

<div class="post-metadata">

**Author:** ![troy](https://avatars.discourse-cdn.com/v4/letter/t/85f322/32.png) [@troy](https://forum.servoy.com/u/troy)\
**Post date:** [October 11, 2010, 9:37pm UTC](https://forum.servoy.com/t/changes-to-plugins-rawsql/13020/3 "2010-10-11T21:37:54Z")

</div>

By logged in what exactly do you mean? If I have enhanced security disabled will that make the rawsql plugin non-functional?

---

<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:** [October 12, 2010, 7:14am UTC](https://forum.servoy.com/t/changes-to-plugins-rawsql/13020/4 "2010-10-12T07:14:50Z")

</div>

Client being logged-in is only checked when enhanced security is on.  
When enhanced security is off the plugin will work as before.

Rob