Re: JDBC question: Execute procedure with plain SQL?

From: Hexathioorthooxalate <ruler_at_removemetoemail.clara.co.uk>
Date: Tue, 29 Mar 2005 18:13:39 +0100
Message-ID: <1112116390.25410.0@lotis.uk.clara.net>

Lookup "java.sql.CallableStatement"

Regards
Hex

"Joe Weinstein" <joeNOSPAM_at_bea.com> wrote in message news:4249850a_at_news.beasys.com...
> Hi all.
> I know that PreparedStatements are the correct means for executing a
> stored procedure,
> but in my current case I am limited to a plain Statement object. Is there
> a SQL string that
> would allow a plain statement to execute a simple non-parameterized
> procedure? Eg:
>
> Statement s = con.createStatement();
> s.execute("execute myProcedureName" );
>
> This doesn't work like SQL-PLUS... The driver just sends the "execute
> myProcedureName"
> to the DBMS and then it fails with a ORA-00900: invalid SQL statement.
>
> Thanks,
> Joe Weinstein at BEA
>
Received on Tue Mar 29 2005 - 11:13:39 CST