Toad cannot format packages containing functions with more than 20 parameter if one parameter is an out parameter.
See below an example of a code that won't be formatted :
CREATE OR REPLACE PACKAGE testpackage AS
FUNCTION testfunc(in_p1 IN NUMBER, in_p2 IN NUMBER, in_p3 IN NUMBER, in_p4 IN NUMBER, in_p5 IN NUMBER,
in_p6 IN NUMBER, in_p7 IN NUMBER, in_p8 IN NUMBER, in_p9 IN NUMBER, in_p10 IN NUMBER,
in_p11 IN NUMBER, in_p12 IN NUMBER, in_p13 IN NUMBER, in_p14 IN NUMBER, in_p15 IN NUMBER,
in_p16 IN NUMBER, in_p17 IN NUMBER, in_p18 IN NUMBER, in_p19 IN NUMBER, in_p20 IN NUMBER,
in_p21 OUT NUMBER, in_p22 IN NUMBER)
RETURN NUMBER;
END testpackage;
Sie müssen sich anmelden und über einen gültigen Servicevertrag verfügen, um auf Premium-Wissensartikel zugreifen zu zu dürfen.
© ALL RIGHTS RESERVED. Feedback Nutzungsbedingungen Datenschutz Cookie Preference Center