DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: error with script

  1. #1
    Join Date
    Dec 2000
    Posts
    8

    Post

    could someone take a look at this script and see what i may have missed. I keep getting an error. I'm in school now for dba.

    SET ECHO OFF
    SET VERIFY OFF

    ACCEPT PID PROMPT 'PLEASE ENTER THE EMPLOYEE''S ID #: '
    ACCEPT PLN PROMPT 'PLEASE ENTER THE EMPLOYEE''S LAST NAME: '
    ACCEPT PFN PROMPT 'PLEASE ENTER THE EMPLOYEE''S FIRST NAME: '
    ACCEPT PS PROMPT 'PLEASE ENTER THE EMPLOYEE''S SALARY: '

    INSERT INTO MY_EMPLOYEE
    VALUES (&PID, '&PLN', '&PFN', LOWER(SUBSTR('&PFN',1,1) || SUBSTR('&PLN',1,15)), &PS);
    SET VERIFY ON
    SET ECHO ON

  2. #2
    Join Date
    Aug 2000
    Posts
    194
    check whether the number of columns in your table (my_EMPLOYEE ) is 5, if not write the DML as
    Insert into my_employee (col1, col2, col3, col4, col5) values (val1, val2, val3, val4, val5) ;

    If this is not the case, post the error message.

Posting Permissions

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


Click Here to Expand Forum to Full Width