search

laurenz / oracle_fdw

PostgreSQL Foreign Data Wrapper for Oracle
http://laurenz.github.io/oracle_fdw/
Other
489 stars 156 forks source link

Call Oracle Procedure #187

Closed fabiozesge closed 7 years ago

fabiozesge commented 7 years ago

Hello, I'm trying to call a oracle procedure using oracle_fdw, but I'm not getting any positive results. In SQLDeveloper I call Execute oracleprocedure (1,2,3)

How can I make this call using oracle_fdw?

laurenz commented 7 years ago

There is no direct way to do that.

You could define an Oracle table with a trigger that calls the procedure when table value are updated and run an UPDATE ... RETURNING statement in PostgreSQL that triggers the procedure.

There might be other similar tricks to achieve that.

laurenz commented 6 years ago

Just for reference, because somebody asked:

Here is an example how that could be done for a function (but you can also call a procdedure in the trigger).