Warning comparison between pointer and integer in C language

I’m assuming that this “type_of_assessment” variable is of char * (pointer to a character) so when you are comparing a character to a char pointer it throws this error. This char * variable stores the address of the actual value stored so you have to de reference it first. Try this in your if condition:

Categories C Tags

PLS-00201 – identifier must be declared

When creating the TABLE under B2BOWNER, be sure to prefix the PL/SQL function with the Schema name; i.e. B2BOWNER.F_SSC_Page_Map_Insert. I did not realize this until the DBAs pointed it out. I could have created the table under my root USER/SCHEMA and the PL/SQL function would have worked fine.