Skip to Main Content

SQLcl

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

PROJECT STAGE while staging table change not working with error ORA-06502 LPX-00409

IgorKowalczykNov 12 2024 — edited Nov 12 2024

I was testing how sqlcl handles creating alter statements for table changes.

In main branch i had commited table:

create table prj_test
(x number, y varchar2(1));

Then I dropped column y in database, PROJECT EXPORTed table into develop branch, commited and executed PROJECT STAGE.

Staging faild with callstack:

ERROR: An error has occurred processing your request:
ORA-06502: PL/SQL: błąd liczby lub wartości
LPX-00409: incorrect token encountered while parsing
ORA-06512: przy "SYS.DBMS_METADATA", linia 12266
ORA-06512: przy "SYS.UTL_XML", linia 462
ORA-06512: przy "SYS.DBMS_METADATA_INT", linia 8249
ORA-06512: przy "SYS.DBMS_METADATA_INT", linia 8396
ORA-06512: przy "SYS.DBMS_METADATA_INT", linia 12637
ORA-06512: przy "SYS.DBMS_METADATA_INT", linia 12847
ORA-06512: przy "SYS.DBMS_METADATA", linia 6196
ORA-06512: przy "SYS.DBMS_METADATA", linia 12253
ORA-06512: przy linia 130

Database version: 19.18.0.0.0

SQLCl version: 24.3.1.311.1631

This post has been answered by IgorKowalczyk on Nov 12 2024
Jump to Answer
Comments
Post Details
Added on Nov 12 2024
1 comment
55 views