Hi
What is the problem with the following code?
Thank you
SET TERM ^ ;
CREATE PROCEDURE SPTR
AS
DECLARE VARIABLE price INTEGER;
DECLARE VARIABLE price1 INTEGER;
DECLARE VARIABLE eid SMALLINT;
DECLARE VARIABLE bsum INTEGER DEFAULT 0;
DECLARE VARIABLE SCTN CURSOR FOR (
Select ID,DBR,CDR
From
Hi Farshid,
What is the problem with the following code?
Without examining it very closely, I see several problems:
CREATE PROCEDURE SPTR
You don't specify any output parameters. But the SUSPEND later on suggests that
you want to return something to the caller. So you need a RETURNS clause.