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;
WORKAROUND
1. Go to View | Toad options | Formatter
2. On the right panel, expand "Oracle formatter option"
3. Expand "List Arrangements"
4. Select "Parameter declarations"
5. On the right panel, change "List Arrangement" to Default
STATUS
Waiting for fix in a future release of Toad for Oracle
© ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center