Hi all, as already written, only exactly ONE statement can be given to the SAP DB JDBC Driver. The complete declaration of a stored procedure is only ONE CREATE DBPROC statement, independent of how complicate and long the procedure code itself is ...
Anyway it was asked for doing something like 'create table x(a int); select * from x' in one call, which is NOT possible. Regards Alexander Schr�der SAP DB, SAP Labs Berlin > -----Original Message----- > From: Lolling, Jan [mailto:[EMAIL PROTECTED] > Sent: Thursday, July 31, 2003 4:05 PM > To: [EMAIL PROTECTED] > Subject: AW: JDBC : Two SQL Commands in one stmt > > > 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 > _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
