Results 1 to 6 of 6
  1. #1
    Join Date
    Jul 2008
    Location
    Ireland
    Posts
    11

    Unanswered: not a valid integer value

    Hi,

    Im pretty new to the whole Oracle world, coming from a teradata background. Im trying to compile a package body and keep getting an error
    'IN_OBJ_NAME' is not a valid integer. The specification has been compiled, both procedures have been declared in here with parameters matching the body.

    I have looked but cant spot the error as this variable is only specified twice in the code as a parameter passed into two procedures, and both times declared as VARCHAR2 - any ideas what could be wrong?

    This is my first post so a big ('please help me') Hello to everyone!

    Cheers,
    Gerard

  2. #2
    Join Date
    Jul 2008
    Location
    Ireland
    Posts
    11
    PROCEDURE save_line (in_obj_name IN VARCHAR2, in_text IN VARCHAR2, in_dt DATE , p_process_id number default null )
    IS
    ....
    VALUES ( g_process_run_id , substr(in_obj_name,1,60), substr(in_text,1,4000), in_dt, USER, USER
    , rec.machine, rec.program ,ncpu_used ,nphy_read ,nredo_size , p_process_id);


    Hope this helps - sorry I couldnt post more, the paymasters might not be pleased if I did!!!!!

  3. #3
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    Why do you expect help to debug code we can not see?

    My car won't go.
    Tell me how to make my car go.
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  4. #4
    Join Date
    Jul 2008
    Location
    Ireland
    Posts
    11
    Tell me what you need to see and I will send it on

  5. #5
    Join Date
    Jul 2008
    Location
    Ireland
    Posts
    11

    the proc code

    I have made a bit more progress on this - I'm sure I'll be back later with another ('unexplained') problem.
    Thanks
    Last edited by GerardMcL_1; 07-07-08 at 10:32.

  6. #6
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    using SQLPLUS along with CUT & PASTE, do the same for TBL_LOG table
    Code:
    SQL> desc TBLSMSRESPONSES
     Name                                      Null?    Type
     ----------------------------------------- -------- ----------------------------
     ADDRESS                                   NOT NULL VARCHAR2(20)
     RESPONSESTARTID                           NOT NULL NUMBER(38)
     RESPONSEENDID                             NOT NULL NUMBER(38)
     EVENTHISTID                               NOT NULL NUMBER(38)
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

Posting Permissions

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