3
Answers

Regular expression to check % within [ and ]

Photo of mahesh

mahesh

13y
1.4k
1
Dear All,
          How to write a  regular expression to check % within [ and ]

Thanks,

Answers (3)

0
Photo of Lance Hutchinson
NA 5 1.7k 11y
Thanks Shankar

I don't understand what you mean by "Where is your Input Value that you are Passing to the Procedure ?".

From what i understand my input parameter in the procedure is given a value by adding a parameter in C# and assigning it its value from 'txtUsername.Text'. Is this a correct assumption?

the table is as follows:

 

PERSONNEL_ID    NUMBER            
F_NAME             VARCHAR2(255 BYTE)    
L_NAME             VARCHAR2(255 BYTE)    
P_USERNAME      VARCHAR2(255 BYTE)    
P_PASSWORD     VARCHAR2(255 BYTE)    
TYPE                VARCHAR2(255 BYTE)    

Hope this is what you asked for. Really appreciate the help

Thanks Lance

0
Photo of Shankar M
NA 3.6k 1.7m 11y

Hi Lance,

Where is your Input Value that you are Passing to the Procedure ?

Can You Please Post your Table Definition here. The 
PL/SQL numeric or value error in C# usually occurs occurs when we try to convert varchar datatype to number datatype and the varchar value cannot be converted to number datatype.

Thanks, Shankar M