Thread Subject: Run Stored Procedure

Hi,

When i run the following:
resultset = runstoredprocedure(dbconn, 'mystoredprocedure',
{'stringParam1', 'stringParam2', 'stringParam3','stringParam4', 1},
{});
??? Error using ==> database.runstoredprocedure at 86
Procedure may return resultset. Use EXEC and FETCH

When i look at the exec docs, they mention the following:

Run a stored procedure with input parameters.
curs = exec(conn,'{call sp_name (parm1,parm2,...)}');

however using the following:

curs = exec(conn,'{call mystoredprocedure
('stringParam1','stringParam2','stringParam3','stringParam4', 1)}');
resultset = fetch(curs);

results in a syntax error.

Any idea on this?

On Nov 16, 2:31 pm, Izzy <iskandarpr...@gmail.com> wrote:
> Hi,
>
> When i run the following:
> resultset = runstoredprocedure(dbconn, 'mystoredprocedure',
> {'stringParam1', 'stringParam2', 'stringParam3','stringParam4', 1},
> {});
> ??? Error using ==> database.runstoredprocedure at 86
> Procedure may return resultset.  Use EXEC and FETCH
>
> When i look at the exec docs, they mention the following:
>
> Run a stored procedure with input parameters.
> curs = exec(conn,'{call sp_name (parm1,parm2,...)}');
>
> however using the following:
>
> curs = exec(conn,'{call mystoredprocedure
> ('stringParam1','stringParam2','stringParam3','stringParam4', 1)}');
> resultset = fetch(curs);
>
> results in a syntax error.
>
> Any idea on this?

Cancel this one , found the solution :) needed to escape the
'''''''' :P