I think thats it is not correct. The oracle driver accect a complete store procedure declaration in one call of methode execute(...). Perhapse you can understand this procedure declaration as one statement. Can I create stored procedures via JDBC calls in SAP DB like oracle driver do ?
Jan -----Urspr�ngliche Nachricht----- Von: Schroeder, Alexander [mailto:[EMAIL PROTECTED] Gesendet: Donnerstag, 31. Juli 2003 15:42 An: 'Danny Tramnitzke'; [EMAIL PROTECTED] Betreff: RE: JDBC : Two SQL Commands in one stmt Hi Danny, it is not possible to execute more than one statement in one call, e.g by separating them with newlines or '//'s or ';' or whatever. Alexander Schr�der SAP DB, SAP Labs Berlin > -----Original Message----- > From: Danny Tramnitzke [mailto:[EMAIL PROTECTED] > Sent: Thursday, July 31, 2003 3:34 PM > To: [EMAIL PROTECTED] > Subject: JDBC : Two SQL Commands in one stmt > > > Hi all again > > I just want to know, if such a sql statement, comming in with > jdbc, works : > > ResultSet rs = stmt.executeQuery("Create Table test > (id integer, name > char(50)) \n//\n Select * from test"); > > best regards, > Danny > > > -- > Using M2, Opera's revolutionary e-mail client: > http://www.opera.com/m2/ > _______________________________________________ > sapdb.general mailing list > [EMAIL PROTECTED] > http://listserv.sap.com/mailman/listinfo/sapdb.general > _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
