Porting embedded SQL from Oracle to Postgres - Mailing list pgsql-interfaces

From Daniel Clayton
Subject Porting embedded SQL from Oracle to Postgres
Date
Msg-id BAY21-F2D31A3ACF54022DE3EA72DD860@phx.gbl
Whole thread Raw
Responses Re: Porting embedded SQL from Oracle to Postgres
Re: Porting embedded SQL from Oracle to Postgres
List pgsql-interfaces
I am getting an error when attempting to compile using ecpg.

ERROR: syntax error at or near "TYPE"

This code was originally written for Oracle using Pro*/C

from header:

#define RAW_BUFFER_SIZE 524287
typedef struct {   long len;   char buffer[RAW_BUFFER_SIZE];
} internalCompiledData_t;

from .pgc :

EXEC SQL TYPE internalCompiledData_t is LONG VARRAW(RAW_BUFFER_SIZE);

static internalCompiledData_t compiledData;



It appears that the syntax EXEC SQL TYPE .. is ... ; is Oracle specific, is 
there a matching syntax for ecpg?
Or possibly a different way to achieve this datatype equivalencing?

Thanks in advance.
Daniel.

_________________________________________________________________
Find the coolest online games @ http://xtramsn.co.nz/gaming



pgsql-interfaces by date:

Previous
From: Zlatko Matić
Date:
Subject: Re: [ODBC] Unbound text box, Text > 255 characters, MSAccess/PostgreSQL
Next
From: Michael Fuhr
Date:
Subject: Re: Porting embedded SQL from Oracle to Postgres