Or Tim. :)

I would first direct you to This Thread for function call syntax.

Second, I would say that would not necessarily be the case. In an Oracle SP, you can manipulate any parameter passed within the SP or function. You can also declare other variables along with their data type and length. You can also set their values to whatever you want within the SP then return that new value back. AFAIK, you can either get back 1 return value or a cursor of results.

Disclaimer: I am not at work right now, so I can not test any of this. If I get a chance, I will try this when I get back later this week or first of next week.

>It looks as if the parameters that are passed in to an Oracle stored procedure must be of the exact size that the data will be when passed back out from Oracle. I may be wrong but I am having some odd problems and think that this is related. If say an empty string variable is passed into an Oracle SP and this will also be an Output parameter, then the data passed back will be truncated. Does anyone know if this is the case? (and I am betting that "anyone" will be Mark <g>).
>
>As always,
>Thanks!
>George