I know the answer for this, list- CallableStatement:).
yang
>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
______________________________________________________
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
