X-Original-To: pgsql-interfaces-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 82B76D971B for ; Sun, 9 Oct 2005 18:57:39 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 50971-07 for ; Sun, 9 Oct 2005 21:57:33 +0000 (GMT) Received: from hotmail.com (bay21-f2.bay21.hotmail.com [65.54.233.91]) by svr1.postgresql.org (Postfix) with ESMTP id 5065CD9209 for ; Sun, 9 Oct 2005 18:57:35 -0300 (ADT) Received: from mail pickup service by hotmail.com with Microsoft SMTPSVC; Sun, 9 Oct 2005 14:57:37 -0700 Message-ID: Received: from 203.118.128.130 by by21fd.bay21.hotmail.msn.com with HTTP; Sun, 09 Oct 2005 21:57:37 GMT X-Originating-IP: [203.118.128.130] X-Originating-Email: [dwbc@hotmail.com] X-Sender: dwbc@hotmail.com From: "Daniel Clayton" To: pgsql-interfaces@postgresql.org Subject: Porting embedded SQL from Oracle to Postgres Date: Mon, 10 Oct 2005 10:57:37 +1300 Mime-Version: 1.0 Content-Type: text/plain; format=flowed X-OriginalArrivalTime: 09 Oct 2005 21:57:37.0620 (UTC) FILETIME=[7639B940:01C5CD1C] X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=1.75 required=5 tests=[DNS_FROM_RFC_ABUSE=0.374, DNS_FROM_RFC_POST=1.376, MSGID_FROM_MTA_HEADER=0] X-Spam-Level: * X-Archive-Number: 200510/6 X-Sequence-Number: 5768 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