Skip to Main Content

SQLcl: MCP Server & SQL Prompt

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!

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
276 views