I am not a db guy, and I have a very beginner's knowledge bout PL/SQL. That being clear now the question:
I have 2 tables one file level & another batch level. In a day, only 1
file_id is possible; but for each
file_id there are multiple batches with different
batch_id and then again for each
batch_id there are multiple documents.
Now, I need something like the simple getters & setters. I want some data from the file level table.. on the basis of that get some data from the batch level table and then get some more data from the files table again.
This was very easy if I had an object & I could simply pass it around & setting stuff & filling up the object with things I want.
How can I do something similar with PL/SQL like passing the same object again & again ??