Porting embedded SQL from Oracle to Postgres

Поиск
Список
Период
Сортировка
От Daniel Clayton
Тема Porting embedded SQL from Oracle to Postgres
Дата
Msg-id BAY21-F2D31A3ACF54022DE3EA72DD860@phx.gbl
обсуждение исходный текст
Ответы Re: Porting embedded SQL from Oracle to Postgres  (Michael Fuhr <mike@fuhr.org>)
Re: Porting embedded SQL from Oracle to Postgres  (Michael Meskes <meskes@postgresql.org>)
Список 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 по дате отправления:

Предыдущее
От: Zlatko Matić
Дата:
Сообщение: Re: [ODBC] Unbound text box, Text > 255 characters, MSAccess/PostgreSQL
Следующее
От: Michael Fuhr
Дата:
Сообщение: Re: Porting embedded SQL from Oracle to Postgres