![]() What worries me about the OP's requirement for one 'main' procedure is that he may be thinking of it like a C program which compiles to a single executable that does the main thing, however many internal sub-programs there may be. There will be individual proc for each procedure with functions called within the procedures for a packageNot sure what you mean, sorry. For a net pay, invoicing or shipping package, does that interface expose the required business steps that need to be performed? Where the public interface can be read, understood and used without even to have to look at the implementation of that? Each of those calls will in turn perform a single business step, and usually will make calls to other procedures and functions too.Ī package's design quality can in part be measured on how well the public interface looks. This main call interface (e.g CalculateNetPay() for an employee) should read like a story - a series of step-by-step calls that performs the required business deed. ![]() Or in your case, something like CalculateNetPay( empID number, salaryMonth date, payment OUT TPaymentRecord ) in the EmployeePayments package. Shipping.ShipInvoice( invoiceNo number ). Likewise, at a program unit level, you need to expose a single public interface for the business processes to call - e.g. However, all this will be set into motion with a single business instruction - +"proceed with the shipping of goods for invoice abc"+. This involves several steps, from checking the goods out of the stores, auto ordering additional goods if stock level has reached the minimum threshold, determining what shipping company to use depending on the type of order and size of goods, updating the invoice to reflect the shipment, sending notifications to customer, printing shipping order, etc. Let's say you need to do a shipping order. ![]() ![]() It is a package that has to be created the part i am confused about it Only one procedure has to be available for ext calls.ALL others procs will be p subroutines that are called by the main procedure in the packageThis is not unusual. 1.7K Training / Learning / Certification.165.3K Java EE (Java Enterprise Edition).7.8K Oracle Database Express Edition (XE). ![]() 3.7K Java and JavaScript in the Database. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
January 2023
Categories |