Hi everyone. Hoping everybody is doing right.
Working with apex 23.2
I have noticed, creating pl/sql functions and procedures with SQL Developer. That when you use a cursor, c4 by example, sometimes not ever, this dont work.
for
example you declare a cursor like this
cursor c4 is select * from user_quest where user = xuser and quest_orden = xorden
when you try to open the cursor it gives you a error. This :
ORA-01722: unable to convert string value containing 'M' to a number:
ORA-03302: (ORA-01722 details) invalid string value: MAILASK
ORA-06512: at "MAILASK.QUESTIONLIST", line 17
ORA-06512: at "MAILASK.QUESTIONLIST", line 74
ORA-06512: at "MAILASK.CREASURVEY", line 37
ORA-06512: at line 13
However, all the items and variables involved are numeric and have numeric values.
Sometimes it is solved by changing any random variable declaration, for example, changing x4 number, by x4 number := 0;
Any idea ?
I'm going to update sqldeveloper version if it is posible.
Regards. Jose.