Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2004
    Posts
    1

    Unanswered: Includes in Procedures written in Developer Center

    Does anyone know if it's possible to Include files (code) in a SP written in Developer Center.

    What i want is something like this

    <This is the working way>
    CREATE PROCEDURE AAAA (IN EMPNUMBR CHAR(6), OUT SQLCPARM INTEGER)
    LANGUAGE SQL

    BEGIN:
    DECLARE SQLCODE INTEGER;
    DECLARE CONTINUE HANDLER FOR SQLEXCEPTION
    SET SQLCPARM = SQLCODE;
    >

    But i want to have the same errorfile to all my sp's.
    <Can i do this>
    CREATE PROCEDURE AAAA (IN EMPNUMBR CHAR(6), OUT SQLCPARM INTEGER)
    LANGUAGE SQL

    BEGIN:
    #INCLUDE errorDeclares
    SET SQLCPARM = SQLCODE;

    >

    Regards

    Bjórn Jonsson

  2. #2
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    No, Only SQL is allowed in a SP. You will need to explicitly declare the stuff each time.

    Andy

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •