RTD Studio Does Not Import A Stored Procedure When it Uses A“TIMESTAMP WITH TIME ZONE” Datatype Column As Input (Doc ID 1605805.1)

Last updated on FEBRUARY 25, 2019

Applies to:

Symptoms

On trying to import a stored procedure that has a parameter with datatype “TIMESTAMP WITH TIME ZONE” using the Oracle Database,

• RTD does not bring in this parameter.
• For Example, for a Stored Procedure as below:

---------------------------------
PROCEDURE X1P_INS_ADVISOR_REQUEST_3
(
in_ADV_REQUEST_DT IN TIMESTAMP WITH TIME ZONE

) IS
BEGIN
DECLARE
SESSION_SEQUENCE_NBR INTEGER := 0;

BEGIN
SELECT COUNT(*)
INTO SESSION_SEQUENCE_NBR
FROM x1t_advisor_request;

END;
END X1P_INS_ADVISOR_REQUEST_3
--------------------------------------

• When importing this into RTD, it shows blank.

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.