Link to home
Start Free TrialLog in
Avatar of Swaminathan K
Swaminathan KFlag for India

asked on

Pro *C giving an compilation error while compiling

Hi Team,

I am new to pro *c program , I have created a c program called insert_data.pc, which does the following . Iam trying to insert into table b in schemaA by invoking a procedure from packageA. \
Iam getting an compile time error


I am compiling using the below command . Database is oracle

proc CODE=cpp CPP_SUFFIX=cpp PARSE=NONE sample.pc

void insert_data(char p_name[] , int p_amount)
{
EXEC SQL AT DBCONNECTIONNAME EXECUTE
                    BEGIN
                         schemaA.packagA.insert_emp_sal(:p_name,:p_amount);
                   END;
END-EXEC;

}

Iam getting the below error when I compile the program as below
PCC-S-02322 , found undefined identifier
                         schemaA.packagA.insert_emp_sal(:p_name,:p_amount);
   
}

Any help is really appreciated.
ASKER CERTIFIED SOLUTION
Avatar of slightwv (䄆 Netminder)
slightwv (䄆 Netminder)

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Swaminathan K

ASKER

thank you