Creating procedure that returns multiple records on joined tables
Hello,
I trying to create a PL/SQL Procedure that will return multiple records using several joined tables.
I've developed this thus far, but this is only sufficient for a single record
create or replace
PROCEDURE "COMPLETED_SERVICE_ORDERS" (
"ZONENAME" IN OUT VARCHAR2,
"T_TRANSDT" OUT DATE,
"DAYS_PASSED" OUT INTEGER,
"C_CUSTOMER" OUT VARCHAR2,
"C_ACCOUNT" OUT VARCHAR2,
"C_ACCOUNTTYPE" OUT VARCHAR2,
"T_INDATETIME" out DATE,
"C_ACCOUNTSTATUS" OUT NUMBER,
"C_LASTNAME" OUT VARCHAR2,
"C_FIRSTNAME" OUT VARCHAR2,
"C_CYCLE" OUT VARCHAR2,
"C_BOOK" OUT VARCHAR2,
"C_ZONE" OUT VARCHAR2,
"T_DATEPRINTED" OUT DATE,
"D_DATETOPRINT" OUT DATE,
"D_DATECOMPLETED" OUT DATE,
I trying to create a PL/SQL Procedure that will return multiple records using several joined tables.
I've developed this thus far, but this is only sufficient for a single record
create or replace
PROCEDURE "COMPLETED_SERVICE_ORDERS" (
"ZONENAME" IN OUT VARCHAR2,
"T_TRANSDT" OUT DATE,
"DAYS_PASSED" OUT INTEGER,
"C_CUSTOMER" OUT VARCHAR2,
"C_ACCOUNT" OUT VARCHAR2,
"C_ACCOUNTTYPE" OUT VARCHAR2,
"T_INDATETIME" out DATE,
"C_ACCOUNTSTATUS" OUT NUMBER,
"C_LASTNAME" OUT VARCHAR2,
"C_FIRSTNAME" OUT VARCHAR2,
"C_CYCLE" OUT VARCHAR2,
"C_BOOK" OUT VARCHAR2,
"C_ZONE" OUT VARCHAR2,
"T_DATEPRINTED" OUT DATE,
"D_DATETOPRINT" OUT DATE,
"D_DATECOMPLETED" OUT DATE,
0