Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> PL/SQL from Java

PL/SQL from Java

From: David Ignjiæ <dignjic_at_activit.sk>
Date: Wed, 1 Aug 2001 20:00:00 +0200
Message-ID: <9k9g3g$3d2j0$1@ID-73468.news.dfncis.de>

ok, bad i have this pl/sql procedure

 function prihlasenie_elm  (icLogin      varchar2,
                             icPassword   varchar2,
                             ocSID        OUT varchar2,
                             onErrProtId  OUT NUMBER) return boolean;

I call this procedure from java
      CallableStatement cstmt = dbConn.prepareCall("{? = call
s_k_prihlasenie.prihlasenie_elm(?, ?, ?, ?)}");
      cstmt.setString(2,login);
      cstmt.setString(3,password);
      cstmt.registerOutParameter(1,Types.INTEGER); //i don't know which type
i must write here????
      cstmt.registerOutParameter(4,Types.VARCHAR);
      cstmt.registerOutParameter(5,Types.NUMERIC);

Thanks for your help.
            David
Received on Wed Aug 01 2001 - 13:00:00 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US