Skip to Main Content
Forums

APEX

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!

I have an error when trying to export SQL scripts, any idea how to resolve this?

Jasper TanglibMar 10 2021 — edited Mar 10 2021

I navigated to SQL Scripts \ Export SQL Scripts and filtered the Owner field who owns the script I want to export. I left the other fields by default where Find field is blank and Row field is 10. When I click the "Go" button it will display "report error: ORA-01722: invalid number".
Here are some things I tried but it returned the same error:
Filtered the Owner field as "- All Users -".
Changed the Row field value from 10 to the other values.
Entered an existing script name in the Find field.
Am I doing something wrong, something missing, or could this be a bug?
Apex version 20.2
Any suggestions or idea is appreciated.

-Jazz

Comments

NickR2600-Oracle

Ha ha, I love how curious and thorough you are!  I'm certain the files are meta-data and scripts which tell NetBeans what files it needs, how they should be organized, and how to compile them.  I've tried messing around with them a few times in order to convert a Java SE 8 project to be a Java SE 9 Modular project.  But I had trouble figuring out all the places that needed changing.  Other than that, I haven't needed to dig too deeply into the role of each file, so I'm not sure which resources would be best.  I'll ask around.

1 person found this helpful
NickR2600-Oracle

Hopefully I'll be able to reach one of the product managers to provide thoughts here on the forum.  In the meantime, they said the information on each file was google-able piece-wise and recommended this stackoverflow thread as an example: https://stackoverflow.com/questions/33772118/difference-between-build-xml-and-build-impl-xml

1 person found this helpful
1 - 2

Post Details

Added on Mar 10 2021
#apex, #apex-discussions, #bug, #export, #script
6 comments
233 views