Workspace Import Gives: ORA-06550: Line 1367, Column 37: PLS-00201: Identifier 'WWV_FLOW_API#VARCHAR
(Doc ID 2226936.1)
Last updated on FEBRUARY 03, 2022
Applies to:
Oracle Database Cloud Service - Version N/A and laterOracle Database Cloud Schema Service - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Application Express (APEX) - Version 5.0.1 and later
Gen 1 Exadata Cloud at Customer (Oracle Exadata Database Cloud Machine) - Version N/A 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
Changes
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
| Symptoms |
| Changes |
| Cause |
| Solution |
| References |