Invalid number with strings that contains comma in oracle procedure

Asked Jun 18 '21 at 22:05

Active Jun 18 '21 at 22:09

Viewed 174 times

I am trying to learn pl/sql.I created a procedure in oracle.Procedure gets input like that 3,4 but when I execute my procedure I get invalid number error.

My procedure is :

 PROCEDURE Student(
  p_types             IN  VARCHAR2,
  p_istatus           OUT      INTEGER
 )
 IS     
 v_value VARCHAR2(2000);

 BEGIN   
 dbms_output.put_line (p_types);  --It prints correctly (3,4)
 SELECT discount_id into v_value FROM Student where type_id in (p_types);
END Student;

My error is : Invalid Number

Do you have any idea?

asked Jun 18 '21 at 22:05

tom

1

Well, `'3,4'` is not a number. It is a string. The SQL expression expects a list of numbers (based on the type of `type_id`), not a string. – Gordon Linoff Jun 18 '21 at 22:07
If you mean you are passing in a string of '3,4', that is not what you are expecting. – OldProgrammer Jun 18 '21 at 22:08
@GordonLinoff how can i convert to number? – tom Jun 18 '21 at 22:31
1

What number are you trying to convert '3,4' to? It's a rhetorical question because (as has been pointed out before) 3,4 is not a number. – BobC Jun 19 '21 at 01:34
I wrote this a million years ago: https://www.williamrobertson.net/documents/comma-separated.html – William Robertson Jun 19 '21 at 13:37

Invalid number with strings that contains comma in oracle procedure

0 Answers0