Call stored procedure using inTeliScript

Nov 13, 2008 at 10:37 AM
Hi all,

How do I call a stored procedure from inTeliScript?
Can it be done?

// svenj
Nov 14, 2008 at 6:30 PM

Yes this is absolutely possible. All you need to do is use the database query action.

Nov 26, 2008 at 3:28 PM

I have a new problem with SP.
The SP i am using have both input and output variables.
Example: SP_Test(in1, in2, out1, out2)
How do I get the two output variables?

I'm using Oracle database.
And I call the SP using CALL.
Nov 30, 2008 at 11:14 PM

Hmmm. Is there any way to return the values from the stored proc as a single row with values in the columns?

Dec 2, 2008 at 10:41 AM

No, I have to use the stored procedure.
I am in no control of the database, I can just use the supplied procedures.
But, do you think it could work with:
SP_Test(1, 1, ?<out1>, ?<out2>);
SP_Test(1, 1, #out1#, #out2#);?

// Svenj
Dec 3, 2008 at 10:55 AM

I think we probably won't be able to access the output parameters since there are some special things that need to be done under the covers to access them (since they are different from a standard returned table row). However you could still accomplish what you are trying to do by creating an inTeliScript plugin in .NET. The .NET assembly could easily use ADO.NET to access the stored proc and return the values. It's pretty easy to do with our plugin architecture. Unfortunately it would require some .NET programming experience.