Parameters in stored procedures
Bart Pietercil
bart.pietercil at gmail.com
Thu Sep 20 06:50:40 CDT 2007
>
>> Is it now possible to pass a cursor back to the calling function? If
>> I understand correct this is now possible:
>
>
>> aCursor = new VCursor
>
>> aCursor = Valentina.ExecuteSQL("CALL sptest()")
>
>> where sptest() looks like this:
>
>> create or replace sptest()
>> Begin
>> select * from tbl_user where user_id = 1;
>> End
>
>> Is this correct ?
>
> Absolutely correct.
>
OK, then next question
If the Stored Procedure generates a valentina error will this error
be known to the client that made the call?
To be more specific, will for a RealBasic Project a
ValentinaException be raised or do we have to handle the error inside
the stored procedure?
TIA
Bart Pietercil
More information about the Valentina
mailing list