Need assistance with Oracle 9i calling stored procedure on SQL Server via Gateway

I'm in serious need of direction & assistance on the use of Transparent gateway from Oracle 9i to a stored procedure on SQL Server. This is taking place in a web environment where the actual execution is taking place on the web server, not a client machine.

In the old Forms 6 environment under client / server (not web), this was accomplished via ODBC on the client machine using the EXEC_SQL facilities to define a connection, cursor, etc., to call the procedures, define columns, return the result set via EXEC_SQL.EXECUTE_AND_FETCH, etc.

In the Forms 9i environment, this is no longer a viable approach. Oracle says we need to make use of transparent gateway, which we have, to accomplish this same task. It should be noted that the stored procedure on the SQL Server side returns a result set, not a simple single value.

If someone has just a handful of lines of code I can use as reference code as to how to go about doing this via the gateway, it would be most appreciated. Responses may be posted here or simply Emailed directly to sdrichardson_at_direcway.com

Thanks in advance for any and all assistance.

• S D R -