running stored procedure through interactive sql session.

[zippyhm]

I am new to sybase server, and am having some trouble debugging. Can anyone tell me how to run stored procedure with more than 1 argument passed in in the interactive sql sessions for testing????

any help would be much appreciated.
cheers
zippy

 

[AVJoson]

Hi,

On isql you can execute the procedure with the procedure name and argument/s. If you want to execute only a part of the entire procedure, you may comment the unrequired part through vi editor and save the file. The command to create the procedure is :r <filename>

Thereafter, you may try executing the procedure from the same isql window and you can check the result. Similarly you can go step by step to check the complete procedure.

I am not sure whether this is what you are looking for. Pls write to me in case you want something else.

Regards,
Joson

 

[zippyhm]

Thanks Joson.

What I actually meant was just how to syntax the arguments at the end (silly right?)

I was doing foo(x,y)
when all I needed was foo x, y

I have been working in informix soo long and assume everything else is the same (which is not a bad assumption most of the time).

Thanks for taking the time to reply to my thread.
Have a nice day
Zippy