Hi Guys,
I am trying to use INSRT in my package procedure for conditional statement, however each time I execute my package it gives me an error: PLS-00382: expression is of wrong type.
Here's what I am currently doing:
If instr(p_workstation_name,'.',12) then <insert statement>
else <another insert statement>
p_workstation_name is a string:
ABCD123EF01.
If the above string has a period sign '.' in it's 12th position then it should perform the insert statement. If not then another insert statement follows.
I am new to Oracle. Any way to achieve the above. Thanks in advance. Really appreciate you responses. :)