Hi, there
Do you have any idea on how to execute a sql statement like:
EXECUTE PK_CRS_TEST.PR_MEMBERSHIP_DELETE(1);
I tried the following, but it give me err:
stella@lewis:~/crs > java TalkOracle
SQLException: ORA-00900: invalid SQL statement
...
try {
con =
DriverManager.getConnection("jdbc:oracle:thin:@192.168.0.225:1526:ARES_L",
usr, pwd);
Statement stmt = con.createStatement();
sql = "EXECUTE PK_CRS_TEST.PR_MEMBERSHIP_DELETE(1)";
boolean rs = stmt.execute(sql);
if (rs) {
System.out.println("we went through");
}
else System.out.println("it returns an update count or there are no
more results");
thanks for help in advance
yang
>From: Thor HW <[EMAIL PROTECTED]>
>Reply-To: Thor HW <[EMAIL PROTECTED]>
>To: [EMAIL PROTECTED]
>Subject: Re: JDBC on Oracle
>Date: Sun, 5 Mar 2000 13:20:53 -0800
>
>Well, if you mean jdk 1.2 to Oracle 815, then you should've read the
>release
>note. It says it doesn't support 1.2, only 1.1. For 1.2 support you have
>to use the supported drivers, which are from the 816 toolset. rtfm
>
>Thor HW
>----- Original Message -----
>From: yves.huguenin <[EMAIL PROTECTED]>
>To: <[EMAIL PROTECTED]>
>Sent: Friday, March 05, 1999 12:45 PM
>Subject: Re: JDBC on Oracle
>
>
> > Try to use the 8i (8.1.5) under Irix form fun.......
> >
> > Thor
> >
> > PS: Happy crash...
> >
> > -----Original Message-----
> > From: A mailing list about Java Server Pages specification and reference
> > [mailto:[EMAIL PROTECTED]]On Behalf Of Thor HW
> > Sent: Wednesday, March 01, 2000 5:06 PM
> > To: [EMAIL PROTECTED]
> > Subject: Re: JDBC on Oracle
> >
> >
> > sigh ... go to technet.oracle.com and download the Oracle8.1.6 driver.
> > Thor HW
> > ----- Original Message -----
> > From: Cheong Takhoe <[EMAIL PROTECTED]>
> > To: <[EMAIL PROTECTED]>
> > Sent: Sunday, February 27, 2000 9:10 PM
> > Subject: JDBC on Oracle
> >
> >
> > > Hi,
> > >
> > > I need help in connecting a JSP application built under JDK 1.2.2 to
>an
> > Oracle 8.0.5 database.
> > > Problem is that the JDBC driver provided by Oracle for 8.0.5 is only
> > compliant with JDK 1.1.1
> > >
> > > Has anyone out there been able to achieve this? Please advise on how
>would
> > I be able to
> > > establish the connection. Direction to sample code or write up would
>be
> > very much appreciated.
> > >
> > > regards,
> > > Cheong Takhoe
> > >
> > >
> >
>===========================================================================
> > > To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff
> > JSP-INTEREST".
> > > FAQs on JSP can be found at:
> > > http://java.sun.com/products/jsp/faq.html
> > > http://www.esperanto.org.nz/jsp/jspfaq.html
> > >
> >
> >
>===========================================================================
> > To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff
> > JSP-INTEREST".
> > Some relevant FAQs on JSP/Servlets can be found at:
> >
> > http://java.sun.com/products/jsp/faq.html
> > http://www.esperanto.org.nz/jsp/jspfaq.html
> > http://www.jguru.com/jguru/faq/faqpage.jsp?name=JSP
> > http://www.jguru.com/jguru/faq/faqpage.jsp?name=Servlets
> >
> >
>===========================================================================
> > To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff
>JSP-INTEREST".
> > Some relevant FAQs on JSP/Servlets can be found at:
> >
> > http://java.sun.com/products/jsp/faq.html
> > http://www.esperanto.org.nz/jsp/jspfaq.html
> > http://www.jguru.com/jguru/faq/faqpage.jsp?name=JSP
> > http://www.jguru.com/jguru/faq/faqpage.jsp?name=Servlets
> >
>
>===========================================================================
>To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff
>JSP-INTEREST".
>Some relevant FAQs on JSP/Servlets can be found at:
>
> http://java.sun.com/products/jsp/faq.html
> http://www.esperanto.org.nz/jsp/jspfaq.html
> http://www.jguru.com/jguru/faq/faqpage.jsp?name=JSP
> http://www.jguru.com/jguru/faq/faqpage.jsp?name=Servlets
______________________________________________________
Get Your Private, Free Email at http://www.hotmail.com
___________________________________________________________________________
To unsubscribe, send email to [EMAIL PROTECTED] and include in the body
of the message "signoff SERVLET-INTEREST".
Archives: http://archives.java.sun.com/archives/servlet-interest.html
Resources: http://java.sun.com/products/servlet/external-resources.html
LISTSERV Help: http://www.lsoft.com/manuals/user/user.html
