I am practicing with a Pro*C program and SQL and I have the following simple program:
#include <stdio.h>
#include <sqlca.h>
char user_id[20]="test/test"
char emp_name[20];
main()
{
EXEC SQL CONNECT :userid;
printf("Connected\n");
EXEC SQL DECLARE emp_cursor CURSOR FOR
SELECT name
FROM badge;
EXEC SQL OPEN emp_cursor;
printf("Employees---------------");
EXEC SQL WHENEVER NOT FOUND DO break;while (1)
{
EXEC SQL FETCH emp_cursor INTO :emp_name;
printf("%s\n", emp_name);
}
EXEC SQL CLOSE emp_cursor;
EXEC SQL COMMIT WORK RELEASE;
exit(0);
}
It simply retrieves all the names from a table called BADGE:
CREATE TABLE BADGE
(
badge_id NUMBER PRIMARY KEY,
name VARCHAR(20),
surname VARCHAR(20) NOT NULL,
birthday DATE
);
However, when I try to compile the source I have the following error:
proc test.pc proc: symbol lookup error: proc: undefined symbol: kgsuglo_
Can anyone help me out with the error?
