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

[Ramzi_Salameh@daveandbusters.com]

You might have to wrap your EXECUTE statement with a BEGIN-SQL / END-SQL
statement.

HTH

------------------------------------------------
Ramzi Salameh
PeopleSoft Technical Analyst
Dave & Busters, Inc.

Voice     (214) 904-2550
Fax       (214) 350-0941
------------------------------------------------


                                                                                
                                                        
                      "srikanth karra"                                          
                                                        
                      <srikanth_karra@h        To:       sqr-users@sqrug.org    
                                                        
                      otmail.com>              cc:                              
                                                        
                      Sent by:                 Subject:  [sqr-users] calling MS 
SQL server Stored Proc from SQR                         
                      sqr-users-admin@s                                         
                                                        
                      qrug.org                                                  
                                                        
                                                                                
                                                        
                                                                                
                                                        
                      12/26/02 02:58 PM                                         
                                                        
                      Please respond to                                         
                                                        
                      sqr-users                                                 
                                                        
                                                                                
                                                        
                                                                                
                                                        




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




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