Hello all,
i am trying to call a stored procedure that returns a reference cursor from
Oracle. All my attempts have resulted in these errors.
I have tried the following:
(1)callableStatement.registerOutParameter(1,OracleTypes.CURSOR);
This gives me this error:
*** Error: "OracleTypes/CURSOR" is e
Hi all,
Can anyone provide code snippets of how to call a
stored procedure which involves multiple selects statements and Joins. Procedure
takes 3 inputs and returns 8 columns.
Can someone provide me with some
examples.
Thanks in advance
Praveen
Hi Claire,
r u using JDBC 2.0 provided by oracle. I have used the same code and is
working perfectly fine.
Mahesh.
-Original Message-
From: Claire Ryan [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, June 21, 2000 3:49 PM
To: [EMAIL PROTECTED]
Subject: Calling Stored Procedures
Hello
sses12.zip,
respectively. It looks like you're going through ODBC.
Mark
-Original Message-
From: Mahesh Kuklani [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, June 21, 2000 3:05 PM
To: [EMAIL PROTECTED]
Subject: Re: Calling Stored Procedures
Hi Claire,
r u using JDBC 2.0 provided by
Hi Clarie,
Import oracle.jdbc.driver.OracleTypes before using OracleTypes.
Hope this helps.
xgh.
- Original Message -
From: Mahesh Kuklani
To: [EMAIL PROTECTED]
Sent: Thursday, June 22, 2000 04:05 AM
Subject: Re: Calling Stored Procedures
Hi Claire,
r u using JDBC 2.0
Does anyone knows if it is possible to call Stored Procedures with JSP's.
I'm using Stored Procedures in Oracle, and some of them return values, but
another ones don't.
Thanks in advance,
José Castro
===
To unsubscribe: mai
= true;
rs.close();
}
cstmt.close();
DB.close();
}
catch (java.lang.Exception ex) {
}
}
return retour;
}
%>
Regards,
Franck
- Message d'origine -
De : "Jose Castro" <[EMAIL PROTECTED]>
À : <[EMAIL PROTECTED]>
Envoyé : vendredi 5 mai
yes you can call stores procedures in jsp.
here is an example
CallableStatement cs = con.prepareCall("{call
PROC_get_next_track_id (?,?,?,?)}");
cs.setString(1,"Track_Id");
cs.registe
jose,
you sure can. call them using jdbc.
Sandeep.
Jose Castro wrote:
> Does anyone knows if it is possible to call Stored Procedures with JSP's.
>
> I'm using Stored Procedures in Oracle, and some of them return values, but
> another ones don't.
>
> Thanks in advance,
> José Castro
>
> ==
You need to create a CallableStatement.
[]'s
Marcelo de Mattos Mayworm
BL Informatica
Tel.: 0xx21 220-3642 0xx24 9901-2929
[EMAIL PROTECTED]
Conhecendo-se a quietude, pode-se possuir a estabilidade.
Conhecendo a estabilidade, pode-se encontrar a serenidade.
Conhecendo a serenidade, pode-se enco
to return value 1 if block 1 executes, 2 if block 2
executes, and so on. So, how should I make changes?
BTW, I am using SQL Server 7.
Regards,
Rajneesh
- Original Message -
From: Franck Rageade <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, May 05, 2000 6:53 PM
Subject:
11 matches
Mail list logo