Results 1 to 2 of 2
  1. #1
    Join Date
    May 2007
    Posts
    2

    Question Unanswered: embedded SQL in Pro*C

    I'm getting this in a Pro*C program with embedded SQL that I've been modifying on Linux:


    rm: cannot lstat `test_data.exe': No such file or directory
    rm: cannot lstat `test_data.o': No such file or directory
    test_data.pc: In function `write_values':
    test_data.pc:3179: cannot convert to a pointer type
    test_data.pc:3179: warning: integer overflow in expression
    test_data.pc:3179: cannot convert to a pointer type
    test_data.pc:3179: warning: integer overflow in expression


    And line 3179 looks like:

    EXEC SQL SELECT COUNT(*) INTO :count FROM SER_NUM
    WHERE
    SER_NUM = :ser_num_pfx||:ser_num_base;

    'ser_num_pfx' and 'ser_num_base' are both VARCHARs, 3 and 5 characters in length, respectively; 'count' is 'int'.

  2. #2
    Join Date
    May 2007
    Posts
    2

    Cool never mind

    That error had been messing with me for a couple of weeks and finally, for some reason, after making some other changes in the code (but in a different routine), I ran my 'build' script and it compiled and linked, and I don't know what the deal is. I made no changes to those lines in question, but now things are OK. Go figure.

Posting Permissions

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