Postgres Pro
Downloads
Home   >   mailing lists

Thread: oracle script to postgresql

oracle script to postgresql

From
"FERREIRA William (COFRAMI)"
Date:
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 ?
 
Regards
 
    Will

Re: oracle script to postgresql

From
"Guy Rouillier"
Date:
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