Re: [SQL] Create connection with Oracle database from Postgres plpgsql

2005-07-05 Thread Bricklen Anderson
Dinesh Pandey wrote: > How can we create connection with Oracle database from Postgres plpgsql > function and execute some oracle stored procedure? > > Thanks > Dinesh You can use perl DBI to access Oracle, providing you have DBI and the plperlu language installed. Sample code that may help you g

Re: [SQL] Create connection with Oracle database from Postgres plpgsql function

2005-07-05 Thread Michael Glaesemann
On Jul 5, 2005, at 6:40 PM, Dinesh Pandey wrote: How can we create connection with Oracle database from Postgres plpgsql function and execute some oracle stored procedure? I don't think it's possible with plpgsql. Try DBI-link. Michael Glaesemann gr

[SQL] Create connection with Oracle database from Postgres plpgsql function

2005-07-05 Thread Dinesh Pandey
How can we create connection with Oracle database from Postgres plpgsql function and execute some oracle stored procedure? Thanks Dinesh