Re: Stored Procedure

From: <apavlov_at_pop.pitt.edu>
Date: 1998/02/24
Message-ID: <34F31640.9A0162CE@pop.pitt.edu>#1/1

Hi,

I modified the code to make a call from java, but I can not figure out what argument type

to pass on.

I do not have problems when I use Sybase or MS SQL Server I get the ResultSet and

all works fine.

Thanks,

Tony

create or replace package types
as

    type cursorType is ref cursor return emp%ROWTYPE; end;
/

create or replace procedure spListEmp (l_cursor IN OUT types.cursortype) as

begin

    open l_cursor for select * from emp order by ename;

end;
/

   Connection con = DBUtil.connect(

                           "jdbc:odbc:oracle8",
                            "scott",
                             "tiger",

  "" );
   System.out.println("Connected...");

   try {

    cstmt = con.prepareCall("{call spListEmp(?)}");     cstmt.set ?????
    ResultSet rs = cstmt.getResultSet();

    ..... Received on Tue Feb 24 1998 - 00:00:00 CST