Hello PL/SQL Guru's,

I am new to programming, but I wanted to write a store procedure that:

Accepts an appID as input and use it to return the card number of any card(s) in an active state associated with the appID, if any from the database.

I want this to work with our software, java.

Could you please give me some examples of how to design this?

Thanks in advance for your help!