Hi,

I would like to run a stored procedure via TMS RemoteDB similar to, https://www.tmssoftware.com/site/forum/forum_posts.asp?TID=8605&title=about-remotedb-txdataset65288stored-procedure .

Is that possible?

Mike,

<< I would like to run a stored procedure via TMS RemoteDB similar to, https://www.tmssoftware.com/site/forum/forum_posts.asp?TID=8605&title=about-remotedb-txdataset65288stored-procedure .

Is that possible ? >>

I'm not familiar with that product, so you'll have to ask about it on their support forums.

Tim Young
Elevate Software
www.elevatesoft.com

Hi Tim,

The TMS product uses the SELECT statement for retrieving datasets.

I noticed the remark "You can only retrieve result sets from procedures from a client (TEDBStoredProc)."in one of your posts here.

Would it be possible to support stored procedures in select statements?

<< Would it be possible to support stored procedures in select statements? >>

Yes this is something I realy miss here in EDB. We shoud be able call a Procedure from a normal TEDBQuery SQL. In Informix I'm able to place "Execute Procedure myProc(a,b)" into the TQuery.SQL and get an resultset like a normal Select back. Of yourse the Procedure must return a cursor.

I would be happy if we get something similar here in EDB, without to use a TEDBStoredProc.

What you can do is this: "SELECT MyFunction()". This works with functions but it doesn't work with a procedures which returns a cursor.

Mike,

<< Would it be possible to support stored procedures in select statements?
>>

No, we cannot do so because of the way that EDB's SQL/PSM implementation works.  Cursors that are returned from procedures/functions/scripts are dynamic and there is no way to gather information about their makeup without actually executing them, and this obviously can have side-effects that aren't good.

Tim Young
Elevate Software
www.elevatesoft.com