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

    Unanswered: Stored Procedure error

    Hello people,

    I am trying to create a store procedure in command center and its throwing

    sqlcode: -104

    sqlstate: 42601

    SP :

    CREATE PROCEDURE abc.abcStoredProcedure6 (IN TriggerDescription VarChar(100), IN TargetPerson VarChar(60))
    LANGUAGE SQL
    BEGIN


    Insert into abc.DATA (Date, Description, Manager) Values (CURRENT DATE,TriggerDescription,TargetPerson);
    select * from abc.DATA;
    END@

    I have a similar SP, which executes fine:

    CREATE PROCEDURE abc.abcStoredProcedure5 (IN TriggerDescription VarChar(100), IN TargetPerson VarChar(60))
    LANGUAGE SQL
    BEGIN


    Insert into abc.DATA (Date, Description, Manager) Values (CURRENT DATE,TriggerDescription,TargetPerson);
    END@

    I am trying to use this my Cognos package and cognos requires the SP to return some values and hence I used the "Select" statement to return some values.

    Any help would be greatly appreciated

  2. #2
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    ---
    "It does not work" is not a valid problem statement.

Posting Permissions

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