Peter ,
This thinks are not working, i filed issues for it
if it is urgent you can try my work around
SUB TESTstoredprocedurecall
oBaseContext = CreateUnoService(com.sun.star.sdb.DatabaseContext)
oDB = oBaseContext.getByName(mysql_native)
oCon = oDB.getConnection(user, Password)
oStatement = oCon.createStatement()
sSQL1 = call teststoredprocedure('Parm1', '¨Parm2') ' must been pased
in right order
ostatement.execute(sSQL1)' gives True
oResultset1 = ostatement.getresultset
oResultSet1.next
print oResultset1.getstring(1)' confirmes the selection based on parameters
ostatement.close ' must been done otherwise we ran in a
Exception:'sdbc.SQLExepetion Commands out of sync, you can not run this
command now
'after this exception you need to restart OO or dispose oDB
ocon.close ' just to be sure everyting isclosed
end sub
Hope it helps
Fernand
Hi Frank, hi Ocke,
Java has a method registerOutParameter(int,int), which e.g. works with
Oracle jdbc like registerOutParameter(1,OracleTypes.CURSOR).
Interface XOutParameters needs a third parameter typeName, which I
tried with
registerOutParameter(1,com.sun.star.sdbc.DataType.REF,oracle.jdbc.OracleTypes.REF).
Invalid name pattern is the answer from sdbc.
It's my first contact with stored procedures, so perhaps you can give
me a hint how to handle this.
Regards
Peter
-
To unsubscribe, e-mail: dev-unsubscr...@dba.openoffice.org
For additional commands, e-mail: dev-h...@dba.openoffice.org
-
To unsubscribe, e-mail: dev-unsubscr...@dba.openoffice.org
For additional commands, e-mail: dev-h...@dba.openoffice.org