Call stored procedure using ExecuteSQL?

[m0nkey]

Hi,

I have recently started using the ExecuteSQL functionality in Filemaker Pro. I can successfully run SQL in FM via an ODBC connection to an Oracle database.

Please can anyone tell me how I can execute a stored procedure held in the Oracle database?

Thanks in advance

Rich.

[Reed]

Hi Rich,

I was able to successfully execute a sProc on MS SQL Server 2008 using the following calculation:

"{CALL Ironwood_RequestDocuments_Delete('"&RequestDocuments_Selected::RequestDocumentUid&"')}"

Ironwood_RequestDocuments_Delete is the name of the sProc

RequestDocuments_Selected::RequestDocumentUid is the filemaker field name with the Uid of the document to delete.

Note that the extra single quotes are needed to quote the sProc parameter in the calculation result.

Not sure how Oracle might be different.

[m0nkey]

Hey Reed,

You are an absolute star, that works perfectly. Thank you ever so much, you have saved me hours and hours of frustration

Thank you, thank you, thank you!