Re: very new to oracle : need stored procedure sample

This is a FAQ... You need to use a REF CURSOR in a procedure.

either refer to the PL/SQL documentation (online at http://technet.oracle.com )
or http://osi.oracle.com/~tkyte/Resultsets/index.html Several final remarks:

• Usually a direct 'port' from one system to another is not the best solution. Oracle didn't have resultsets until very recent, and the package has been able to do without it. Also, a one on one translation usually doesn't teach you the full power of the new software.
• Please search the newsgroup archives at www.deja.com
• Please avoid crossposting to multiple oracle newsgroups. PL/SQL is a server issue only.

Regards,

Sybrand Bakker, Oracle DBA

Christian BRUNO <brunoc_at_ifrance.com> wrote in message news:8asp9v$pco$1_at_minus.oleane.net...
> hello,
>
> i'm new to oracle 8 (migrating from SQL Server) and i want to call, via
> ODBC, a procedure stored on the
> oracle server
>
> this procedure should give me the same result as an sql "select" order
>
> please, tell me how to write this procedure
>
> i've tried this :
>
> CREATE OR REPLACE PROCEDURE spFindCustInfo ( in_code IN VARCHAR(8) )
> IS
> BEGIN
> select CUSTEXT,CUSTADDRESS1 from CUSTOMERS where CUSCODE=in_code;
> END;
> /
>
> but it does not compile
>
> help!!!
> Christian
>
>
>
>
>
Received on Fri Mar 17 2000 - 04:04:35 CST