Calling a Procedure from a view

[WizZerD]

Now my next problem..

I have made this simple Procedure & stored it.
PROCEDURE: GetAnmarkning
Parameters
Receive String: sAnmarkning
Local Variables
String: sSQL
Actions
Set sSQL = 'select ANMARKNING from UPPSKICKSRAD where BESTID = :sAnmarkning into :sAnmarkning'
Call SqlImmediate(sSQL);

Now I want to call the procedure in my view. Can I just add:
EXECUTE GetAnmarkning('1234')
in the select statement ?

I have tried, but get:
Error: 00134 SQL CNO ERROR.SQL NOT FOUND LOOKING UP ERROR 05041

I can't find any examples of how to do this.
Any help ?

/Nigel

 

[WizZerD]

Maybe I need to clarify myself.

I need to call a procedure from a select statement, and ultimately from a view..

For example

SELECT UserID, NAME, GetAddress(UserID) FROM CONTACTS

Where GetAddress() is a Procedure that returns an address string for the UserID.

Can anyone help ?

/Nigel