Re: Prepared Statement and Stored Procedure

francan00@xxxxxxxxx wrote:
For SQL in my web applications I use PreparedStatement object alot in
my JDBC working with Oracle 9i.

I also heard the term Stored Procedure. What is the difference between
Stored Procedure and Prepared Statement?

What is the difference between a Ford car and an apple ?

:-)

PreparedStatement is something you use to execute SQL statement.

A stored procedures is something that most database have (in sligthly
incompatible syntax) that allow you to write "SQL scripts" within
the database (actually in Oracle you can write stored procedures
in Java as well but ...).

To execute a store procedure you would use CallableStatement.

Arne

.

Relevant Pages

  • Re: Oracle connectivity
    ... You haven't said whether you are working with Oracle Lite on the device ... Oracle.Lite.Data.dll which is a .NETCF provider for the database. ... > - Execute an Oracle PL/SQL stored procedure designed to return ... > Write a Web Service, most likely of the XML variety, to run on the host. ...
    (microsoft.public.dotnet.framework.compactframework)
  • Re: Error in calling stored procedure via DB link
    ... "Paul Clement" wrote: ... Below is an Oracle KB article that documents the issue. ... Calling Stored Procedure over Dblink Using Oracle OleDb Provider Fails ... > symptom: Using command type adCmdStoredProc ...
    (microsoft.public.vb.database.ado)
  • Re: Performance problems with StoredProcedure in Web application
    ... you could probably just ignore my comments about stored procedure performance as compared to textual queries because they ... As for your question about how to avoid using a cursor (as I suggested was possible in Oracle) read the following paragraph for more ... The .NET Framework Data Provider for Oracle does not support batched SQL statements. ... CURSOR output parameters to fill a DataSet, ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: Passing Back Table Information from Oracle .NET Stored Procedures
    ... stored procedure, not in the typical PL/SQL sense. ... I don't care if it's MS SQL in-line code or Oracle in-line code, MS SQL Server, Oracle Proc, or this so called .NET Stored Procedure using a Select statement, they are all returning a RESULT SET whether it be one row or multiple rows. ... I used SqlContext above because I don't want to bother registering at the Oracle site to download their Oracle Database Extensions for .NET in order to get at the presumably extant OracleContext class. ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: EXEC syntax for SP which returns row set
    ... >>> Oracle experts, none of whom seem to know. ... >> SQL> create or replace package returncur is ... > I don't know why you are supplying the above example. ... to illustrate HOW you'd call a stored procedure and return ...
    (comp.databases.oracle.server)