How do you pass to a stored procedure a param?

I can sqlexec( gn_handle, 'execute my_stored_proc','my_return')

But when my_proc has an param I cant send it.

I've tried the SQLPREPARE() as the help file shows but that won't work and return data period.

I am working with the pubs database and the byroyalty stored procedure as a test. My data is similar so this is an easy attempt.

I want to pass 100 to byroyalty and get the list back from it.

Any takers out there?

__Stephen Russell