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
Re: Porting embedded SQL from Oracle to Postgres |
| Список | 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 по дате отправления: