Software version:
Problem description:
InterBase stored procedures take input and output parameters. It shows up differently in the metadata extraction (Procedure Properties in ADS). ADS is showing the parameters by alphabetic order, rather than the defined sequence of parameters. Input order is even more important to be correct because callers pass in values for each of those parameters as per the originally defined order.
Steps:
1. Create empty database, and create following stored procedure.
CREATE PROCEDURE Procedure_Param_Order (
Input_Before INTEGER,
Input_After INTEGER
)
RETURNS (Output_Start INTEGER,
Output_Middle NUMERIC(15, 2),
Output_End INTEGER
)
AS
BEGIN
/* This stored procedure should have this order of input and output parameters..
If it shows up differently in the metadata extraction, there is something
wrong in the application showing the parameters in order. Input order is even
more important to be correct because callers pass in values for each of those
parameters in the originally defined order.
Use command line tool, isql, or IBConsole GUI tool to verify metadata extraction */
/* Input Parameters:
1st parameter: Input_Before
2nd parameter: Input_After
Output/Result Parameters:
1st parameter: OutPut_Start
2nd parameter: OutPut_Middle
3rd parameter: OutPut_End
*/
EXIT;
END;
COMMIT;
2. Connect to database file from ADS
3. Explore Procedure Properties for the test procedure. You will notice that the input and output arguments are not in the defined order as above. Please see attached screenshot showing the issues in ADS.
4. You can use the command line InterBase tool, isql, or the GUI tool, IBConsole, to verify that they are showing the arguments in the proper order.
243 KB
Issue #15888 |
New |
Completion |
No due date |
No fixed build |
No time estimate |