Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Executing Procedures From Microsoft Access 97

Re: Executing Procedures From Microsoft Access 97

From: Keith Lawrence <false_at_no.spam>
Date: 1998/02/13
Message-ID: <6c20o9$cu9$1@news.u-net.com>#1/1 







dosberg_at_yahoo.com wrote in message <887384299.334823435_at_dejanews.com>...


>I have inherited an Oracle database with an Access client(front end).  I

>want to kick off an Oracle procedure using an Access pass-through query.

>I have tried several syntax variations but keep getting an error message

>telling me "invalid SQL Statement."





Syntax is (the {} is actually part of the syntax)


    {CALL objowner.procname(param1,param2...)}



Keith L
Received on Fri Feb 13 1998 - 00:00:00 CST












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US