I have a package body that have procedure for inserting data. it takes cursor to iterate. I have put cursor in header file. Is there any way we can have the sql select query in some file and refer the query from file into cursor.
Please help or let me know any way so that i can manage queries in some property file and refer query into cursor from this file.
posted 5 years ago
Maybe you could create a sql_properties package if you have that
many cursors . the package would contain all cursor sql used by other packages.
The using packages could execute dynamic cursors or sql_properties package
could contain the actual open- fetch- close cursor logic invoked by other packages.