Parameters in stored procedures

[Ivan Smahin]

Hello Bart,

Thursday, September 20, 2007, 1:36:05 PM, you wrote:

> 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)

create  or  replace spName( IN/OUT/INOUT VarName varType, IN/OUT/INOUT
VarName2 varType, ...)

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

Ok.

> 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 ?

Absolutely correct.



-- 
Best regards,
Ivan Smahin 
Senior Software Engineer
Paradigma Software, Inc
Valentina - The Ultra-Fast Database
http://www.valentina-db.com