PL/SQL (MOSC)

MOSC Banner

Creating procedure that returns multiple records on joined tables

edited Jun 29, 2011 10:12AM in PL/SQL (MOSC) 3 commentsAnswered
 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,

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center