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: Billy Verreynne <vslabs_at_onwe.co.za>
Date: 1998/02/16
Message-ID: <6c90lh$bb5$1@hermes.is.co.za>#1/1

Billy Verreynne wrote in message <6c90ee$b8j$1_at_hermes.is.co.za>...
>
>Try wrapping the stored procedure call with begin and end, e.g.
>
>BEGIN; package1.sp2('var1'); END

Correction - the syntax is:

BEGIN package1.sp2('var1'); END;

The BEGIN does not need to be terminated, by the END does (standard PL/SQL syntax).

regards,
Billy Received on Mon Feb 16 1998 - 00:00:00 CST

Original text of this message

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