I think since stored procedures differ across db's you can make whatever
conventions you want. Is this for execute sp's only? How do select sp's
fit into this?

david jencks

On 2001.12.09 16:06:29 -0500 rrokytskyy wrote:
> Hi again,
>
> currently I am trying to implement the correct support of escaped
> syntax in the callable statement. but, seems to me that the code i'm
> trying to get work might be an overkill for the FB.
>
> Escaped syntax of form {call proc_name(?, ?,...)} allows both IN and
> OUT parameters in the call. Unfortunately, Firebird (and InterBase)
> do allow only IN parameters in procedure call, OUT are represented by
> the ResultSet. The consequence of this is, that escaped syntax
> containing IN and OUT params cannot be prepared directly.
>
> Since I don't have big experience with stored procedures throught
> JDBC, I need your input, how IN and OUT params look there:
>
> - first go IN, then OUT?
> - mixed IN and OUT?
> - can constant expression (not "?") be an OUT parameter?
>
> Thanks in advance,
> Roman Rokytskyy
>
>
>
> To unsubscribe from this group, send an email to:
> IB-Java-unsubscribe@egroups.com
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>
>
>
>