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