LinuxQuestions.org

LinuxQuestions.org (/questions/)
-   Linux - General (https://www.linuxquestions.org/questions/linux-general-1/)
-   -   error with embedded SQL in Pro*C (https://www.linuxquestions.org/questions/linux-general-1/error-with-embedded-sql-in-pro%2Ac-550374/)

cleopard 05-01-2007 08:46 AM

error with 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'.

cleopard 05-10-2007 10:51 AM

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.


All times are GMT -5. The time now is 07:45 AM.