Call stored procedure using inTeliScript

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

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

// svenj
Coordinator
Nov 14, 2008 at 5:30 PM
svenj,

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

-alpha
Nov 26, 2008 at 2:28 PM
Hi,

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.
Coordinator
Nov 30, 2008 at 10:14 PM
svenj,

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

-alpha
Dec 2, 2008 at 9:41 AM
Hi,

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>);
or
SP_Test(1, 1, #out1#, #out2#);?

// Svenj
Coordinator
Dec 3, 2008 at 9:55 AM
svenj,

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.

-alpha