Here is what I’m trying to do:

I have three tables.

This is probably simple but I cannot find a good example online. I have 5 cursors I would like to iterate through in succession (loop through all of cursor 1, then loop through all of cursor 2, etc). The caveat is that I (believe I) need to open all the cursors at the same time, because I am deleting records in the loops that would affect the output of the select statements in the latter cursors… I want the cursors to reflect the output at the beginning of the program’s execution, not at the start of the loop for the cursor.

I have a schema-level record type and a schema-level table type, and I want to fill this table with records.

I am trying to insert data into table which have values more than 4000 character, to overcome with this i have made column qcnotes datatype clob on zzz_drop_result_718001 but i couldn’t get it done.

I am trying to insert data into table which have values more than 4000 character, to overcome with this i have made column qcnotes datatype clob on zzz_drop_result_718001 but i couldn’t get it done.

I created my own Oracle type and aggregation function from it:

I want to use a code like this:

I have a requirement where I have different IDs but I want to show the count of total no of rows in the table in every row.

One row of data exists for each combination of project_id and task number but it is throwing no data found error.
SELECT into throws error, but just a select with where clause is fetching one row of data.
Here is the procedure