Parameters in stored procedures

[Bart Pietercil]

Hi List,

I am a bit lost on the required syntax for passing parameters to a  
stored procedure.
If I want to send multiple parameters what do I do ?

1) create or replace sp1( IN logonname,logonpassword VARCHAR, OUT ok  
BOOLEAN)

or

2) create or replace sp1( IN logonname VARCHAR, IN logonpassword  
VARCHAR, OUT ok BOOLEAN)

or

3) create or replace sp1(IN logonname,logonpassword VARCHAR,OUT ok  
BOOLEAN)


I think the explanation (or the examples) on the WIKI could be better  
regarding this function.

On a similar matter:

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 ?

Thx

Bart Pietercil