Board index » delphi » Executing Select stored procedures in a SQL statement

Executing Select stored procedures in a SQL statement

The following statement gives a "no current record or fetch operation error"

select * from table t, SP_SOME_FUNTION( t.field1 )    

??

 

Re:Executing Select stored procedures in a SQL statement


Hi,
did you use "SUSPEND" operator within SP?
With best regards,
Sergey.

--
I am looking for a job in EU.
I have no a work permit.

Re:Executing Select stored procedures in a SQL statement


Quote
> The following statement gives a "no current record or fetch operation error"

> select * from table t, SP_SOME_FUNTION( t.field1 )

Such construction is not supported.
Depending on details, either wrap all functionality into another procedure,
or use scalar subselect, e.g.

  select t.*, (select x from SP_SOME_FUNTION( t.field1)) from table t

Ivan

Other Threads