[sqr-users] calling MS SQL server Stored Proc from SQR

["srikanth karra" <srikanth_karra@hotmail.com>]

Hi,

I'm new to SQR group.

Please anybody help me with the problem I'm facing right now, when calling 
the Stored Proc from SQR

this is the SQR used:
BEGIN-PROGRAM
Let #MAX=17

DO STORED_PROCEDURE_DATA_FETCH
IF #SUCCESS != 0
        LET $ERROR_MESSAGE = 'EXECUTION OF THE STORED PROCEDURE FAILED'
        DISPLAY $ERROR_MESSAGE
        STOP QUIET
END-IF
END-PROGRAM

BEGIN-PROCEDURE STORED_PROCEDURE_DATA_FETCH

EXECUTE ON-ERROR=SQL_ERROR
        DO=PRINT_DATA
        @#success=sp_kpi_getcurrency
    INTO &currency_id Integer,
         &description char(30)

END-PROCEDURE

BEGIN-PROCEDURE  PRINT_DATA

PRINT   &currency_id  (+1,30,0)
END-PROCEDURE

BEGIN-PROCEDURE   SQL_ERROR
LET $ERROR_MESSAGE = 'THE FOLLOWING DATABASE ERROR WAS ENCOUNTERED:'
                        || $SQL_ERROR
STOP QUIET
END-PROCEDURE

And this is my error:

Error on line 19:
   (SQR 3908) Unknown datatype for EXECUTE...INTO &columns.
    INTO &currency_id Integer,

Error on line 20:
   (SQR 3900) EXECUTE command is incomplete.
      &description char(30)
(SQR 4407) Referenced variables not defined:

  &currency_id

Errors were found in the program file.

SQR: Program Aborting.

I have checked for the datatypes in the table, they match.

Thanks,

srikanth






_________________________________________________________________
Protect your PC - get McAfee.com VirusScan Online 
http://clinic.mcafee.com/clinic/ibuy/campaign.asp?cid=3963

_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users