Skip to Main Content
Forums

SQL & PL/SQL

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!

Can I use a WITH() closure in a procedure?

I have a script that I run in Oracle Database 19c 19.0.0.0.0.0.0, and I use two date parameters from - to in a WITH() closure then depending on what it returns it does the INSERT to a table, then I wonder if it is possible to use my SQL statement in a procedure for this case, it is for an orchestrator that does not allow the SQL statement because of the number of lines, since it exceeds the maximum and I have to use a procedure.
It is the first time that I am going to use a procedure and I did not find information if I can use a with() closure and the parameters in a procedure, thank you.

I attach the SQL statement that I execute, thank you for your attention
SQL Insert F59INVEN.txt (11.26 KB)
This post has been answered by Frank Kulash on Oct 27 2021
Jump to Answer

Comments

Your Linux is 64-bit, Java ME VM is 32-bit application, so 32-bit support libraries have to be installed before you can use ME SDK. This is actually described in docs: https://docs.oracle.com/javame/8.2/sdk-dev-guide/install.htm#sthref10

Docs has an example how to do it under Ubuntu, but under CentOS this also should not be a problem.

Please, also, note that CentOS is not officially supported platform.

1 - 1

Post Details

Added on Oct 27 2021
#plsql, #procedure, #sql
3 comments
253 views
2 mentions