explicitly return a value from a called procedure

[JackTheDog]

I would like to explicitly return a value from a called procedure without using the OUTPUT parameter. I can't seem to get this to work and get an error regarding converting to int. It's a string I want to pass & I've declared all of the pertinant variables as varchar.

Do I have to use this OUTPUT parameter?? I don't think Oracle recognizes this and as we may be migrating in the near future I want to make sure we've got as little recoding to do as possible.
Thanks
Sue

 

[cdukes]

Yes,
You can use a return parameter from a stored procedure but you cannot return a string. You can only return an integer.

If I remember correctly, Oracle does support OUTPUT parameters to functions.

Hope this helps,

Chris Dukes