Sorry,
My stupid fault. I accidentally set ParamCheck of my TIBSQL (IBX) to False.
Robert.

> > >>SELECT VAR1
> > FROM STOREDPROC(:VAR2)
> >
> > But I get this prepare error:
> >
> > Dynamic SQL Error
> > SQL error code = -206
> > Column unknown
> > VAR2
> >
> > Executing the next statement gives no problem:
> >
> > SELECT VAR1
> > FROM STOREDPROC(1)
> >
> > The stored procedure is declared as (simplified, just for example):
> >
> > CREATE PROCEDURE STOREDPROC(VAR2 INTEGER)
> > RETURNS (VAR1 INTEGER)
> > AS
> > BEGIN
> > VAR1 = 2*VAR2;
> > SUSPEND;
> > END
> >
> > >>Can someone explain the error?
> >
> > I am a little confused here. If you are trying to execute SELECT VAR1
> FROM
> > STOREDPROC(1) outside of a SP then it should return 2 with no problem

just

> > like you said.
> >
> > However, you cannot pass it a parameter outside of a SP. If its inside
> > another SP you would have to have a variable defined to catch the output
> for
> > one thing. Inside the other SP you would execute
> > SELECT VAR1 FROM STOREDPROC(:VAR2) INTO :TEMP_VARIABLE;
> >
> > VAR2 would be a passed parameter for SP executing the statement.
> >
> > Hope this helps.