Subject | Re: [IBO] Error executing sp |
---|---|
Author | Scott Taylor |
Post date | 2004-06-05T15:04:31Z |
constantijnw said:
your SP needs to suspend in order to work properly:
CREATE PROCEDURE SP_3
RETURNS ( ACCOUNTID INTEGER )
AS
BEGIN
ACCOUNTID = 1;
SUSPEND;
END
Then to see the output you need to select it:
SELECT * from SP_3
You didn't get any value returned by IB_Cursor because you didn't SUSPEND
after the assignment.
But I'm just a lerking newbie, I'm probably missing something, because I
can't get an error like the one you get. =P
--
Scott
> --- In IBObjects@yahoogroups.com, "Alan McDonald" <alan@m...> wrote:I think what Alan is tryint to tell you, is you are using it all wrong.
your SP needs to suspend in order to work properly:
CREATE PROCEDURE SP_3
RETURNS ( ACCOUNTID INTEGER )
AS
BEGIN
ACCOUNTID = 1;
SUSPEND;
END
Then to see the output you need to select it:
SELECT * from SP_3
You didn't get any value returned by IB_Cursor because you didn't SUSPEND
after the assignment.
But I'm just a lerking newbie, I'm probably missing something, because I
can't get an error like the one you get. =P
--
Scott