Re: [GENERAL] stored procedure from oracle to pgsql

2005-01-19 Thread Joshua D. Drake
Nefnifi, Kasem wrote: Dear, I'm new in pgsql, come from oracle and sql server. any one can help by transferring a pl/sql procedure that imports data from a flat file, using UTL_FILE, and inserts or updates tables. bellow the proc: You can't do this from pl/PgSQL. You will need to use plPerl, plP

[GENERAL] stored procedure from oracle to pgsql

2005-01-19 Thread Nefnifi, Kasem
Dear, I'm new in pgsql, come from oracle and sql server. any one can help by transferring a pl/sql procedure that imports data from a flat file, using UTL_FILE, and inserts or updates tables. bellow the proc: CREATE OR REPLACE Procedure UPD is sOracleMsg varchar2(512); sCusto