From mboxrd@z Thu Jan 1 00:00:00 1970 Path: main.gmane.org!not-for-mail From: Kevin Dziulko Newsgroups: gmane.emacs.help Subject: Re: Looking for mode for Oracle Pro*C. AKA embedded SQL/C. Date: Mon, 19 May 2003 08:19:16 -0400 (EDT) Sender: help-gnu-emacs-bounces+gnu-help-gnu-emacs=m.gmane.org@gnu.org Message-ID: References: <873cjedp2f.fsf@tiger.rapttech.com.au> NNTP-Posting-Host: main.gmane.org Mime-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII X-Trace: main.gmane.org 1053348540 18285 80.91.224.249 (19 May 2003 12:49:00 GMT) X-Complaints-To: usenet@main.gmane.org NNTP-Posting-Date: Mon, 19 May 2003 12:49:00 +0000 (UTC) Original-X-From: help-gnu-emacs-bounces+gnu-help-gnu-emacs=m.gmane.org@gnu.org Mon May 19 14:48:58 2003 Return-path: Original-Received: from monty-python.gnu.org ([199.232.76.173]) by main.gmane.org with esmtp (Exim 3.35 #1 (Debian)) id 19Hk2x-0004aj-00 for ; Mon, 19 May 2003 14:47:19 +0200 Original-Received: from localhost ([127.0.0.1] helo=monty-python.gnu.org) by monty-python.gnu.org with esmtp (Exim 4.10.13) id 19Hk2P-0005FZ-00 for gnu-help-gnu-emacs@m.gmane.org; Mon, 19 May 2003 08:46:45 -0400 Original-Received: from list by monty-python.gnu.org with tmda-scanned (Exim 4.10.13) id 19HjnZ-0002Ya-00 for help-gnu-emacs@gnu.org; Mon, 19 May 2003 08:31:25 -0400 Original-Received: from mail by monty-python.gnu.org with spam-scanned (Exim 4.10.13) id 19HjcV-0008M3-00 for help-gnu-emacs@gnu.org; Mon, 19 May 2003 08:20:00 -0400 Original-Received: from klaatu.canisius.edu ([138.92.8.100]) by monty-python.gnu.org with esmtp (Exim 4.10.13) id 19Hjbp-00087x-00 for help-gnu-emacs@gnu.org; Mon, 19 May 2003 08:19:17 -0400 Original-Received: from localhost (dziulko@localhost) by klaatu.canisius.edu (8.11.6/8.11.6) with ESMTP id h4JCJGK09241 for ; Mon, 19 May 2003 08:19:16 -0400 Original-To: help-gnu-emacs@gnu.org In-Reply-To: <873cjedp2f.fsf@tiger.rapttech.com.au> X-BeenThere: help-gnu-emacs@gnu.org X-Mailman-Version: 2.1b5 Precedence: list List-Id: Users list for the GNU Emacs text editor List-Help: List-Post: List-Subscribe: , List-Archive: List-Unsubscribe: , Errors-To: help-gnu-emacs-bounces+gnu-help-gnu-emacs=m.gmane.org@gnu.org Xref: main.gmane.org gmane.emacs.help:9874 X-Report-Spam: http://spam.gmane.org/gmane.emacs.help:9874 On 17 May 2003, Tim X wrote: > >>>>> "Mamouliane" == Mamouliane writes: > > Mamouliane> Oracle Pro*C is basically a pre-processor. It takes a > Mamouliane> source file written in C and containing SQL > Mamouliane> statements. Hence the name embedded SQL. The > Mamouliane> pre-processor replaces all SQL statements by C statements > Mamouliane> & function calls. In the end what you have is C source > Mamouliane> code that is then compiled and linked with Oracle > Mamouliane> libraries. This is a very basic description of what it > Mamouliane> does but you get the idea. > > Mamouliane> Is anyone aware of such a mode available for Pro*C? I > Mamouliane> know of a SQL mode and PL/SQL mode but can't find a mode > Mamouliane> for Pro*C or embedded SQL/C. Should I write such a mode? > Mamouliane> Is it very difficult? It would basically be an extension > Mamouliane> to the available C mode. There is already modes for SQL > Mamouliane> and PL/SQL out there so I figure I would use that too. > > Before writing your own mode, maybe check out multi-mode-mode which > allows you to use multiple modes in one buffer. I've not used it > myself, but remember seeing an article in one of the newsgroups where > someone was using sql-mode and c-mode for Oracle proc. > > Tim > > Please let us know if this works well or not. I also write c code with embedded SQL, and often get frustrated that indentation doesn't work the way that I would like it too. I am using esqlc for ingres. Thanks!