I can’t get oConnection = ThisDatabaseDocument.CurrentController.ActiveConnection
+ oStmt = oConnection.prepareCall("CALL NEWDA(?,?,?,?,?,?,?)")
to work, throws an exception err()=1
I even tried oConnection.prepareCall("NEWDA(?,?,?,?,?,?,?)")
, oConnection.prepareCall("CALL ""NEWDA""(?,?,?,?,?,?,?)")
, oConnection.prepareCall("NEWDA(?,?,?,?,?,?,?)")
. createCall
(mentioned somewhere) throws the (logical) 423 (method does not exist)
I even granted user FULL PRIVILEGES, and changed PROCEDURE TO match credentials
the Workbench shows:
CREATE DEFINER=myspecialusername
@%
PROCEDURE NEWDA
(IN afm char(9),
IN toplace integer,
IN carnum varchar(15),
IN descr text,
IN quantity integer,
IN skopos text,
OUT newnum integer)
BEGIN …