I am using Oracle 19c.
I am trying to update some student stored grades using a PL/SQL stored procedure.
The stored procedure needs to parameter one is School year which is a number datatype, the other is schools, I hope it is a comma delimited string with schoolID in it , for example, 12, 18, 201, 206, 209.
Everytime we want to pass school year usually is current year, and a list of school ID, then the stored procedure goes to loop to update the stored grades for the students. Both schoolyearID and schoolID are numbers.
My question is how to write the two parameters one is a number, the other is a string of comma delimited numbers in the argument part of the stored procedure? And how the other pl/sql code to call the stored procedure?
Our senoria is we wrote a stored procedure and a wrapper to call the stored procedure, and let a person that knows little about coding to just run the code in sql developer to call the stored procedure and pass the string of a list of schoolids that she finished process.
Thanks