oracle script to postgresql

FERREIRA William (COFRAMI) wrote:

hi,

i'm trying to port an oracle script to postgresql, but i don't find
any alternative for some problems this is an extract of the oracle
script :

DEFINE MDNSImportBlobDirectory =
C:\Temp\_lm_\ExternalTablesSpace\mdns;
@createFraweWorkTables_script.ddl; @createMDNSProcStockImport.sql
&MDNSImportBlobDirectory;

so i need to declare variables and to pass them to others script

is there any alternative for doing this ?

You can define variables in PG functions and pass them to other
functions:

DECLARE

numRows integer := 5;

BEGIN

perform add_5_min_table(numRows);

--
Guy Rouillier