Re: ODBC and stored procedures

Jo Coutuer <100414.1243_at_CompuServe.COM> wrote:
>I would like to find out how calling a stored procedure is
>possible with an Oracle 7.1 database attached through ODBC.
>

Use an anonymous PL/SQL block as the "SQL statement" in the ODBC call:

begin

   stored_proc_name(args);
end;

OR

begin

    package_name.proc_name(args);
end;

Use the latter if your stored procedure is part of a package. You can keep everything on one "line" if you wish but don't forget the semicolons!

NB: you will NOT be able to obtain any returned value from the stored procedure via ODBC. Period.

Use exceptions if you must return an error indicaton to the calling program.

--
Bill Meahan  Ford Motor Company, End User Support-North America
wmeahan_at_sun1.fsic.ford.com
Not an official statement of Ford Motor Company or anyone else besides 
the author (although my dog tends to agree with everything I say)