Categories: MSDN / DotNet / Java / Scripts / Linux / PHP Ask - La ask - La Answer

sybase stored procedure

I have to use a stored procedure in one of my sql statement
e.g.
UPDATE tbTable
SET fdField1 = myProc ( fdField2, fdField3)
WHERE
fdField4=someval

its giving error as sybase allows only built in functions here.

It was possbile in oracle by creating a function.
Any help? Any workarounds?
[344 byte] By [Uttamrao] at [2007-11-11 7:49:49]