here is the code :

Attached file contains the code of 3 parts.

  1. Calling a stored procedure, oracle database, using the
  oracle thin driver.

  2. Code using <jrun:storedproc> tag where I marked
  sqltype="????" in <jrun:sqlparam> as I can't find a matching
  type for reference cursors in java.sql.Types.

  3. Code using <jrun:storedproc> tag which returns a parameter
  of type "INTEGER" also gives the exception.


  AppServer : Jrun 3.1
  JDBCDriver: Oracle thin driver, classes12.zip from oracle.com.

At 09:29 10/01/03 +0200, you wrote:
>Hello,
>
>Please write the piece of code where you call the database procedure.
>
>Catalin
>
>
>----- Original Message -----
>From: "Greg Griffiths" <greg2@s...>
>To: "Pro_JavaServer_Pages" <pro_jsp@p...>
>Sent: Thursday, January 09, 2003 11:30 PM
>Subject: [pro_jsp] Stored Procedure
>
>
> > I am having some problems with JSP and stored procedures with JRun, if the
> > procedure has no parameters it works fine, but if there are parameters I
> > get an error, I'm sure I've got the syntax correct.
> >
> >
> >
>
>