Marc Santhoff wrote:
Am Samstag, den 13.02.2010, 18:22 +0100 schrieb Marc Santhoff:
And just here i am lost: how works this registering of the
parameters ?
Dunno, my assumption was that it is not strictly necessary ... I tink
someone else has to answer this question.
A quick look into chapter 8 of the HSQL docs shows:
<quote>
The routine body is a SQL statement. In its simplest form, the body is a
single SQL statement. A simple example of a function is given below:
An example of the use of the function in an SQL statement is given
below:
SELECT an_hour_before(event_timestamp) AS notification_timestamp, event_name
FROM events;
</quote>
The other SQL statement for calling procedures, in contrast to
functions, would be "CALL".
So chances are good that a prepared statement on the OOo side of things
is sufficient for transferring parameters to a statement build up by a
stored function or stored procedure call.
HTH anyway,
Marc
Hi Marc
That is good for single return values, but not for returning multiple
parameters or for returning a cursor to a result set.
So, sure there is some access to the stored procedures with the current
implementation but it isn't yet ready to take full advantage them - IMO.
Thanks,
Drew
--
Drew's Blog <http://drewjensen.typepad.com>
The Windowsill <http://baseanswers.spaces.live.com/>
Open Vistas <http://drewjensen.blogspot.com/>
