Results 1 to 4 of 4
  1. #1
    Join Date
    Mar 2012
    Posts
    8

    Red face Unanswered: Error in creation of stored procedure

    I'm getting the following error while trying to create the sp in IBM data studio.
    Help me in resolving the issue:

    CREATE PROCEDURE ADMINISTRATOR.INSERTFROMP8
    (IN P_SOMESTRING VARCHAR(64),IN P_WHEN VARCHAR(64))
    LANGUAGE SQL
    INSERT INTO ADMINISTRATOR.LEAGACYTABLE(SOMESTRING,DATED) VALUES (P_SOMESTRING, P_WHEN)

    "ADMINISTRATOR.LEAGACYTABLE" is an undefined name.. SQLCODE=-204, SQLSTATE=42704, DRIVER=4.12.79

  2. #2
    Join Date
    Mar 2009
    Posts
    16
    Hi Mudit,

    Either the table used in the insert query does not exist in your database or is created in some another schema.
    Check for the table schema.

  3. #3
    Join Date
    Mar 2012
    Posts
    8

    Question

    I didn't mention any schema for the table and table exist in database of administrator but i'm accessing it through P8Admin user having all privileges to access db.

  4. #4
    Join Date
    Mar 2012
    Posts
    8

    Smile Problem Resolved

    Thanks Problem Resolved.

Posting Permissions

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