11/13/2023 0 Comments Jetbrains datagrip stored proceduresWhen you select to run in that tool and others the following anon block is executed: DECLAREĭBMS_OUTPUT. When executed in Oracle SQL Developer for 2023 you get the results below: WHERE A.YEAR = COALESCE(P_YEAR,EXTRACT(YEAR FROM SYSDATE)) Select 'Fonzie', 'Liley', 29524, 2022 FROM DUAL All IDEs based on the IntelliJ Platform have Version Control System integration. ![]() Note that I'm pretty sure you need to have created a function in order to see the routines folder. You can also turn on 'Seperate Procedures and Functions' to see them in different folders. For instance, you can learn in which stored procedures, functions or views. Select 'JOHN', 'DOE', 13503, 2023 FROM DUAL In Routines section of the database tree. DataGrip lets you find the usages of objects inside the source code of other objects. Select 'JANE' AS FIRST_NAME, 'DOE' AS LAST_NAME, 105999 AS SALES, 2023 AS YEAR FROM DUAL SELECT A.FIRST_NAME, A.LAST_NAME, A.SALES, A.YEAR create or replace PROCEDURE SP_RPT_SALES ( The expectation is that the REF_CURSOR is captured and the contents are displayed in a grid or at least you offer that ability to the end users when they choose to run the procedure. In DataGrip we have a source code storage: when DG syncs the schema, we have all the sources in the local storage which actual for the moment of synchronization. In DG when you select to run a procedure it runs but for those that return an SYS_REFCURSOR you don't see the output. ![]() Most of my efforts in the db are spent creating procedures whose sole purpose is to provide data to a report which means the procedure returns an SYS_REFCURSOR.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |