Hi,
For our procedure/function template it would be nice too have something as an array of variables. We want to create a parameter list like this:
CREATE OR REPLACE PROCEDURE EVENT_CREATE_EDITASK_B
(
in_cMessageType IN EDI_TASKS.MESSTYPE%TYPE,
in_cTableName IN EDI_TASKS.TABNAME%TYPE,
in_cClientNumber IN EDI_TASKS.KUNDENNR%TYPE,
in_iFunctionCode IN EDI_TASKS.FUNKTION%TYPE,
in_cOrderNumber IN EDI_TASKS.ORDERNR%TYPE,
in_iLineItem IN EDI_TASKS.LINEITEM%TYPE,
in_cTriggeredBy IN EDI_TASKS.TRIGGEREDBY%TYPE,
in_iTriggeredOn IN EDI_TASKS.TRIGGEREDON%TYPE,
in_iEventNumber IN EVENT_STATUS.EVENTNR%TYPE,
in_iActionNumber IN EVENT_STATUS.AKTIONNR%TYPE,
in_iEAENumber IN EVENT_STATUS.EAENR%TYPE,
out_iReturn OUT NUMBER
)
/**
* Diese Prozedur legt ein EDI-Task mit den uebergebenen Parametern
* an. Ausserdem enthaelt diese Prozedur ein entsprechendes Fehler-
* handling, wenn die Anlage des EDI-Tasks fehlschlaegt.
*
* %param in_cMessageType Art der Edi Auftrag (Task)
* %param in_cTableName Bezugs Tabelle fuer Auftragsnummer und Positionsnummer
* %param in_cClientNumber Mandantennummer
* %param in_iFunctionCode Funktionscode
* %param in_cOrderNumber Auftragsnummer
* %param in_iLineItem Positionsnummer
* %param in_cTriggeredBy Art der Ausloeser
* %param in_iTriggeredOn Status wobei das Event ausgeloest ist
* %param in_iEventNumber Nummer des Events
* %param in_iActionNumber Nummer der Aktion
* %param in_iEAENumber Sequencenummer der Aktion
* %param out_iReturn Returncode 0: Okay
So is it somehow possible to have an array of variables (Two demensional) I think of something like giving n-times a combination of Name (in_iLineItem), Mode (list = """IN"","" OUT"", ""IN OUT"""), type (NUMBER...) and description.
Any proposals how to handle this?
For our procedure/function template it would be nice too have something as an array of variables. We want to create a parameter list like this:
CREATE OR REPLACE PROCEDURE EVENT_CREATE_EDITASK_B
(
in_cMessageType IN EDI_TASKS.MESSTYPE%TYPE,
in_cTableName IN EDI_TASKS.TABNAME%TYPE,
in_cClientNumber IN EDI_TASKS.KUNDENNR%TYPE,
in_iFunctionCode IN EDI_TASKS.FUNKTION%TYPE,
in_cOrderNumber IN EDI_TASKS.ORDERNR%TYPE,
in_iLineItem IN EDI_TASKS.LINEITEM%TYPE,
in_cTriggeredBy IN EDI_TASKS.TRIGGEREDBY%TYPE,
in_iTriggeredOn IN EDI_TASKS.TRIGGEREDON%TYPE,
in_iEventNumber IN EVENT_STATUS.EVENTNR%TYPE,
in_iActionNumber IN EVENT_STATUS.AKTIONNR%TYPE,
in_iEAENumber IN EVENT_STATUS.EAENR%TYPE,
out_iReturn OUT NUMBER
)
/**
* Diese Prozedur legt ein EDI-Task mit den uebergebenen Parametern
* an. Ausserdem enthaelt diese Prozedur ein entsprechendes Fehler-
* handling, wenn die Anlage des EDI-Tasks fehlschlaegt.
*
* %param in_cMessageType Art der Edi Auftrag (Task)
* %param in_cTableName Bezugs Tabelle fuer Auftragsnummer und Positionsnummer
* %param in_cClientNumber Mandantennummer
* %param in_iFunctionCode Funktionscode
* %param in_cOrderNumber Auftragsnummer
* %param in_iLineItem Positionsnummer
* %param in_cTriggeredBy Art der Ausloeser
* %param in_iTriggeredOn Status wobei das Event ausgeloest ist
* %param in_iEventNumber Nummer des Events
* %param in_iActionNumber Nummer der Aktion
* %param in_iEAENumber Sequencenummer der Aktion
* %param out_iReturn Returncode 0: Okay
So is it somehow possible to have an array of variables (Two demensional) I think of something like giving n-times a combination of Name (in_iLineItem), Mode (list = """IN"","" OUT"", ""IN OUT"""), type (NUMBER...) and description.
Any proposals how to handle this?
