Results 1 to 3 of 3
  1. #1
    Join Date
    Jan 2003
    Posts
    67

    Unanswered: ORA-01008: not all variables bound

    I'm getting an error: "ORA-01008: not all variables bound" when I try to run the following sql. Any idea why; please let me know what you think.
    Code:
    INSERT INTO WEBCZCS.CZCS_USERS 
    (USER_NAME, USERID, CUSTID, FIRST_NAME, LAST_NAME, 
    UPASSWORD, UPDATE_DATE,CREATE_DATE, UPDATE_USERID, 
    USER_EMAIL, PASSWORDHASH, SALT)
    VALUES ('someuser', WEBCZCS.USERID.NEXTVAL, 
                1, 'Somefn', 'Someln', 
                'apassword', SYSDATE, SYSDATE, 1, 
                'someemail@some.com', '333', 'eee')
    RETURNING USERID INTO :oUSERID;
    Thanks for you help!

  2. #2
    Join Date
    Nov 2002
    Location
    Desk, slightly south of keyboard
    Posts
    697
    Hi,

    I think you need to remove the : from the final oUserId.

    Hth
    Bill
    Please don't email me directly with questions. I've probably just got home from the pub and cannot guarantee the sanity of my answers. In fact, I can't believe I actually made it home.

  3. #3
    Join Date
    Jan 2003
    Posts
    67
    If I remove the ":" I get a "ORA-00905 missing keyword" error.

    Thanks for your help.

Posting Permissions

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