Re: problem calling stored procedure
From: <rtproffitt_at_my-deja.com>
Date: Wed, 20 Oct 1999 21:24:44 GMT
Message-ID: <7ulbuc$pkm$1_at_nnrp1.deja.com>
Date: Wed, 20 Oct 1999 21:24:44 GMT
Message-ID: <7ulbuc$pkm$1_at_nnrp1.deja.com>
- Have you tried NameofProc in the SQL call (not EXEC NameOfProc) (remember that Sql/plus can say it two ways: exec NameofProc -- or -- Declare Begin NameofProc; End; /
- Does VB have a Stored Procedure object? Delphi had a separate Stored Procedure object instead of a straight SQL query object.
Robert Proffitt
In article <7uich8$k50$1_at_newsread.do.de.uu.net>,
"Andreas Reichl" <reichl_at_knuut.de> wrote:
> Hello,
>
> i have a problem calling a stored procedure on an
> Oracle 7 server (NT) from within a VB4 program
> ( PassThrough mode ).
>
> I have tried several ODBC-Drivers ( Microsoft,
> Oracle ), but i always get an ORA-00900
> ( = "invalid SQL statement" ) - everything else in
> PassThrough mode works.
>
> My Procedure can be called from within SQLPlus
> with
> Exec NameOfProc
> ( no parameters or return value ).
>
> Thanks.
>
> Andreas Reichl
>
>
Sent via Deja.com http://www.deja.com/
Before you buy.
Received on Wed Oct 20 1999 - 23:24:44 CEST