View Single Post

   
  #1 (permalink)  
Old 04-08-2008, 06:15 PM
uttamrao
 
Posts: n/a
Default sybase stored procedure problem

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?
Reply With Quote