calling oracle stored procedure

[ipmurali]

hai gurus,
can any body give the syntax to call a stored procedure in oracle from vb6

thanks in advance

[Clunietp]

FYI:

I have read that there is no compatible cursor type with oracle DBs & stored procedures (possibly via 3rd party drivers) so calling stored procedures that return > 1 records won't work properly, you need to embed the SQL in your code....

[ipmurali]

what about procedures which do not return records, i mean action queires.

[Clunietp]

I would assume that they are not a problem....but I don't know oracle...