Forum Stats

  • 3,855,131 Users
  • 2,264,463 Discussions
  • 7,905,904 Comments

Discussions

Comparing String Arrays Pointer

3875643
3875643 Member Posts: 7
edited Jan 27, 2019 4:16PM in Multitenant

Sorry,  I did not know capitalized words are shouting

Need help from an Expert.( This is a Pro*C code)

I need to comapare


i need to compare a string array ( char elementname[5]) with a column (elname varchar2(5)) in a table by a function void get_name(* char).

the contents of the element name is  got from another table by this select elname into :elementname where condition is met ( this part is ok, i have the elementname='iron'.

but when i pass the elementname in a function get_name(elementname) to do a comparision in where it does not work:

function get_name(elementname) {
          select       x,y,z      
          from q       
          where elname=:elementname;
}

this condition can not work, since the where condition does not accept the statement elname=:elementname; (to compare a pointer char with a column (elname varchar2(5)) .

could someone help me out, please.

thanks

Message was edited by: 3875643

Message was edited by: 3875643