9.4 How to Run Oracle Procedure from TI

[rfielden]

Sorry in inconvience board but the support or lack of from IBM is killing me!

I am trying to run an Oracle Prodedure using a TI process. This procedure runs fine for Oracle and last step in completing my application.

1) I tried running as an ODBC with the following query:
BEGIN
{SERVER}.POPULATE_LSM2;
COMMIT;
END;

2) Tried the following two methods using TI None method:

a. ODBCOpen('Server','User','password');
ODBCOutput('Server','EXECUTE POPULATE_LSM2;');
ODBCClose('Server');

b. vSql = 'EXECUTE populate_lsm2';
ODBCOpen('Server','User','password');
ODBCOutput('Server',vSql);
ODBCClose('Server');

As always, any insight or advice would be appreciated.

[rfielden]

The solution:

as stated earlier when we modified the ODBC process to remove the query and tried executing the stored procedure from the Prolog tab using:
ODBCOpen('Server','User','pw');
ODBCOutput('Server','EXECUTE POPULATE_LSM2;');
ODBCClose('Server');
it should have worked as Applix supports says "since this is how I've seen stored procedures run from within TI in the past, this *SHOULD* have worked."

Per their developer...
changing the ODBCOutput statement to the following (changing how we were running the stored procedure):
ODBCOutput('Server','{call POPULATE_LSM2}'); seems to have resolved the issue and allowed the TI Process to run successfully consistently.

[lotsaram]

Coincidence perhaps? IBM TM1 troubleshooting tip from Nov 13