04-29-2020 05:14 AM
In GMSC 2020 I've created sql trigger that should execute oracle procedure:
<WorkflowTrigger name="UtworzKonsultacjeSqlTrigger" method="action" type="SqlTrigger">
<Param name="Sql" value="execute GCW.UTWORZ_KONSULTACJE('a', 'a', 's');" />
Unfortunatelly when I call trigger, I get the following error:
29.04.2020 14:04:57 ERROR - Controller Trigger has raised an exception in Action FireData.
Oracle.DataAccess.Client.OracleException: ORA-00900: invalid SQL statement
at Oracle.DataAccess.Client.OracleException.HandleErrorHelper(Int32 errCode, OracleConnection conn, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src, String procedure, Boolean bCheck, Int32 isRecoverable, OracleLogicalTransaction m_OracleLogicalTransaction)
at Oracle.DataAccess.Client.OracleException.HandleError(Int32 errCode, OracleConnection conn, String procedure, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src, Boolean bCheck, OracleLogicalTransaction m_OracleLogicalTransaction)
How to execute Oracle procedure correctly?
Solved! Go to Solution.
04-29-2020 06:41 AM
I think you need a custom trigger as you need to tell it that the Oracle command type is a stored procedure and not a plain query. Similar was discussed here:
Which leads to the older (no longer maintained) blog:
04-29-2020 07:01 AM
Thanks for the reply.
According to https://geomediasmartclient.wordpress.com/2013/06/11/execute-stored-procedures-in-gmsc-workflows/ I need to write my own extension to GMSC, I mean write c# code, compile it and put dll library file somewhere in GMSC folder. Am I right?
04-30-2020 12:59 AM
Yes, see more info here:
Or, looking for "Custom trigger" term here on Community yields into some results too.