Workspace Import Gives: ORA-06550: Line 1367, Column 37: PLS-00201: Identifier 'WWV_FLOW_API#VARCHAR (Doc ID 2226936.1)

Last updated on JANUARY 30, 2017

Applies to:

Oracle Application Express (formerly HTML DB) - Version 5.0.1 and later
Information in this document applies to any platform.

Symptoms

On APEX 5.X

When attempting to import a Workspace exported on APEX 5.0.1 or lower
the following error occurs.

ERROR FROM GUI
-----------------------
Execution of the statement was unsuccessful. ORA-06550: line 1367, column 37: PLS-00201: identifier 'WWV_FLOW_API#VARCHAR2_TO_BLOB' must be declared ORA-06550: line 1358, column 1: PL/SQL: Statement ignored

begin

wwv_flow_api.g_varchar2_table := wwv_flow_api.empty_varchar2_table;

wwv_flow_api.g_varchar2_table(1) := '89504E470D0A1A0A0000000D49484452000001900000019008020000000FDDA19B0000000373424954080808DBE14FE0000000097048597300000EC400000EC401952B0E1B0000200049444154789CD4BDEB96E4B6AE26F801A01459977D3B97EE356B7E';

wwv_flow_api.g_varchar2_table(2) := 'CC5BCD6BCDA3CC4B4DF739DBDB7655DE22422201CC0F500C86A488CC2C7BFB7473D9514A89A24012FC08802048FFEFFFF37F0320225C27778F9B666666F127333373E48FA7EE1E4F4B2971879614D7EEDEDF6CF74B29D84B5B4A765314DB53728BFE55FE';
---------------------

 

ERROR FROM SQL*PLUS

----------------

ERROR at line 4:
ORA-06550: line 1358, column 1:
PLS-00306: wrong number or types of arguments in call to 'CREATE_FND_USER'
ORA-06550: line 1358, column 1:
PL/SQL: Statement ignored

---------------------



STEPS
-----------------------
The issue can be reproduced at will with the following steps:

1.- Export A Workspace from apex 5.0.1 or 5.0


2. Using the GUI or sql*plus try to import this workspace into any apex 5.0.1 or higher


Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms